Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What did I do? (Select Method of Range Class Failed )
I've been running some code successfully for a few weeks now, the only thing
that I've changed is that I now copy a range of data from the Main Sheet to a Working Sheet before I start manipulating the data. I haven't change the actual code below that now gives me the ERROR "Selection Method of Range class Failed" Set Rng = Worksheets(SheetName2).UsedRange.Rows 'I Get the Error trying to execute the next line Application.Worksheets(SheetName2).Range("A" & First_Row, "G" & Rng.Rows.Count).Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select method of Range class failed - but why??? | Excel Programming | |||
select method of range class failed | Excel Programming | |||
select method of range class failed | Excel Programming | |||
select method of range class failed | Excel Programming | |||
error 1004 Select method of Range class failed | Excel Programming |