Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- 141.8K All Categories
- 104.8K Programming Languages
- 6.4K Assembler Developer
- 1.9K Basic
- 39.9K C and C++
- 4.3K C#
- 7.9K Delphi and Kylix
- 4 Haskell
- 9.6K Java
- 4.1K Pascal
- 1.3K Perl
- 2K PHP
- 523 Python
- 37 Ruby
- 4.3K VB.NET
- 1.6K VBA
- 20.8K Visual Basic
- 2.6K Game programming
- 312 Console programming
- 89 DirectX Game dev
- 1 Minecraft
- 110 Newbie Game Programmers
- 2 Oculus Rift
- 8.9K Applications
- 1.8K Computer Graphics
- 732 Computer Hardware
- 3.5K Database & SQL
- 525 Electronics development
- 1.6K Matlab
- 628 Sound & Music
- 257 XML Development
- 3.3K Classifieds
- 198 Co-operative Projects
- 189 For sale
- 189 FreeLance Software City
- 1.9K Jobs Available
- 601 Jobs Wanted
- 201 Wanted
- 2.9K Microsoft .NET
- 1.7K ASP.NET
- 1.1K .NET General
- 3.3K Miscellaneous
- 5 Join the Team
- 0 User Profiles
- 353 Comments on this site
- 62 Computer Emulators
- 2.1K General programming
- 187 New programming languages
- 612 Off topic board
- 177 Mobile & Wireless
- 51 Android
- 124 Palm Pilot
- 335 Multimedia
- 151 Demo programming
- 184 MP3 programming
- 0 Bash scripts
- 22 Cloud Computing
- 53 FreeBSD
- 1.7K LINUX programming
- 368 MS-DOS
- 0 Shell scripting
- 320 Windows CE & Pocket PC
- 4.1K Windows programming
- 906 Software Development
- 408 Algorithms
- 68 Object Orientation
- 89 Project Management
- 90 Quality & Testing
- 250 Security
- 7.6K WEB-Development
- 1.8K Active Server Pages
- 61 AJAX
- 2 Bootstrap Themes
- 55 CGI Development
- 19 ColdFusion
- 224 Flash development
- 1.4K HTML & WEB-Design
- 1.4K Internet Development
- 2.2K JavaScript
- 35 JQuery
- 290 WEB Servers
- 152 WEB-Services / SOAP
Macro - changing value depending on the original value
liborpops
Member Posts: 4
in Visual Basic
Hello,
Can you please kindly help me to avoid lots of slavish work?
I have a column where there are - among others - also cells with the following values:
$$$to be sent
$$$to be sent2
$$$to be sent3
$$$to be sent4
$$$to be sent5
The active cell is just in this column (the cell is selected). I want a macro which would change these values (nothing else) in THIS column into $$$sent, preserving the eventual number indexes (meaning "$$$to be sent" into "$$$sent", "$$$to be sent2" into "$$$sent2" ....... ). (The cells not containing any of the above values should be left intact).
Please ask me for more explanation if convenient.
Very many thanks in advance!
Lib
Can you please kindly help me to avoid lots of slavish work?
I have a column where there are - among others - also cells with the following values:
$$$to be sent
$$$to be sent2
$$$to be sent3
$$$to be sent4
$$$to be sent5
The active cell is just in this column (the cell is selected). I want a macro which would change these values (nothing else) in THIS column into $$$sent, preserving the eventual number indexes (meaning "$$$to be sent" into "$$$sent", "$$$to be sent2" into "$$$sent2" ....... ). (The cells not containing any of the above values should be left intact).
Please ask me for more explanation if convenient.
Very many thanks in advance!
Lib
Terms of use / Privacy statement / Publisher: Lars Hagelin
Programmers Heaven articles / Programmers Heaven files / Programmers Heaven uploaded content / Programmers Heaven C Sharp ebook / Operated by CommunityHeaven LLC
© 1997-2015 Programmersheaven.com - All rights reserved.