| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i fix this macro?
Maybe there's a difference in what you type and what's in the cell???
(Leading/trailing/extra embedded spaces???) "Hinojosa via OfficeKB.com" wrote: Yes sir i have tried with all caps and all lowercase but still it just doesn't do anything. Dave Peterson wrote: Unless you do something special, this line is case sensitive: If r.Value = s Then So ASDF won't match asdf or AsDf or ASDf or ASdF or... maybe it would be as simple as: if lcase(r.value) = lcase(s) then This is the macro I'm using now: [quoted text clipped - 18 lines] -- Message posted via http://www.officekb.com -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Threaded Mode
