Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- 141K All Categories
- 103.7K Programming Languages
- 6.5K Assembler Developer
- 1.9K Basic
- 40K C and C++
- 2.9K C#
- 7.9K Delphi and Kylix
- 4 Haskell
- 9.7K Java
- 4.1K Pascal
- 1.3K Perl
- 2K PHP
- 551 Python
- 37 Ruby
- 4.4K VB.NET
- 1.6K VBA
- 20.9K Visual Basic
- 2.6K Game programming
- 317 Console programming
- 92 DirectX Game dev
- 1 Minecraft
- 112 Newbie Game Programmers
- 2 Oculus Rift
- 9K Applications
- 1.8K Computer Graphics
- 742 Computer Hardware
- 3.4K Database & SQL
- 535 Electronics development
- 1.6K Matlab
- 628 Sound & Music
- 258 XML Development
- 3.3K Classifieds
- 199 Co-operative Projects
- 198 For sale
- 190 FreeLance Software City
- 1.9K Jobs Available
- 603 Jobs Wanted
- 210 Wanted
- 2.9K Microsoft .NET
- 1.8K ASP.NET
- 1.1K .NET General
- 3.4K Miscellaneous
- 8 Join the Team
- 355 Comments on this site
- 70 Computer Emulators
- 2.1K General programming
- 187 New programming languages
- 627 Off topic board
- 214 Mobile & Wireless
- 86 Android
- 126 Palm Pilot
- 339 Multimedia
- 155 Demo programming
- 184 MP3 programming
- Bash scripts
- 27 Cloud Computing
- 53 FreeBSD
- 1.7K LINUX programming
- 370 MS-DOS
- Shell scripting
- 321 Windows CE & Pocket PC
- 4.1K Windows programming
- 942 Software Development
- 417 Algorithms
- 68 Object Orientation
- 92 Project Management
- 95 Quality & Testing
- 269 Security
- 7.7K WEB-Development
- 1.8K Active Server Pages
- 62 AJAX
- 4 Bootstrap Themes
- 55 CGI Development
- 28 ColdFusion
- 224 Flash development
- 1.4K HTML & WEB-Design
- 1.4K Internet Development
- 2.2K JavaScript
- 37 JQuery
- 308 WEB Servers
- 150 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
© 1997-2015 Programmersheaven.com - All rights reserved.