Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop copying down values
Hi,
I'm not sure how to modify an excel macro to stop copying down values from adjacent column when no data found in auto-filtering. Say, an excel macro is set to copy down data range from A3 to K50 ( ie the last used cell ) where the auto-filtering set on header J2 to filter out value 0 in J column. Excel Macro will copy down values from A3 to K column last used cell for both data found ( is value 0 ) and no data found ( ie blank cell ) in filtering column J How to set excel macro to stop coping down values from A3 to K column of last used cells, for no data found in column J after filtering the value 0 Thanks & Regards Len |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop People Copying a Workbook | Excel Discussion (Misc queries) | |||
Stop the 'intelligent' copying? | Excel Discussion (Misc queries) | |||
Stop the 'intelligent' copying? | Excel Discussion (Misc queries) | |||
Stop Copying at Specific Row | Excel Programming | |||
A way to stop or limit copying ? | Excel Programming |