Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple macro
I use the vlookup on dozens of sheets each day, always returning #n/a
somewhere in the column. So I copy, paste value, then replace #n/a with nothing. When I tried to make a macro do do it, instead of the highlighted range on the new sheet it wanted to find the original sheet and ranges. What do I need to look at whatever is highligted on the active sheet, copy, paste value, and replace #n/a with nothing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
maybe it's simple with macro for this one? | Excel Worksheet Functions | |||
Simple (?) Macro | Excel Discussion (Misc queries) | |||
Simple Macro | Excel Discussion (Misc queries) | |||
Simple macro help | Excel Discussion (Misc queries) | |||
Can't get simple macro to run | Excel Worksheet Functions |