Macro trouble

G

gilbertS

Joined
Apr 14, 2011
Messages
1
Reaction score
0
Hi

I am trying to write a macro to basically find a value in a variable range of data and then amend that value to another value (effectively want to do a loop macro as the data files will vary from 5 rows of data to 100+

Basically if a cell = icelolly then it should change to lolly, i have tried it with find and replace but it just is a bit too easy for it too fall over, especially as i have 11 different values i need to amend. and possibly more at a later stage.

I have tried writing an if command but it doesnt seem to work and i cant figure out what i am doing wrong.

if someone could point me in the right direction would be appreciated.

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Complex search and replace macro based on input variables. 12
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Pasting cell contents into a macro 1
Using Sub RDB_Merge_Data() 6
Pivot table macro filter data between yesterday and today (date+time) 0
[VBA] Identify cell rows based on criteria and sum contents of corresponding cells 3

Top