| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error, when autofilter does not return visible rows
Hi,
I have following problem: I'm using Autofilter to select data from a sheet and transfer it a different sheet. Unfortunally, when no data is found by autofilter I get following error message on 3rd line of the following code: "Run time error 1004 - no cells were found". Does anybody have an idea how to avoid this error? Range(Cells(2, 1), Cells(No_Rows_Source, 1)).Select Set Rng = Selection Set RngVis = Rng.SpecialCells(xlVisible) For Each Cll In RangVis ..... Next Kind regards, AXEL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel copy only visible rows from autofilter | Excel Discussion (Misc queries) | |||
| Autofilter: jump from visible row to visible row by command button | Excel Programming | |||
| countif for only visible rows when combined with autofilter - possible? | Excel Discussion (Misc queries) | |||
| AutoFilter: Loop Thru Visible Rows? | Excel Programming | |||
| AutoFilter - which rows are currently visible? | Excel Programming | |||
Threaded Mode
