Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Operating on hidden sheets
Hi,
Let's say I have a "Sheet1" which is hidden. Programmatically WITHOUT UNHIDING the above sheet, I go ahead and write sheet1.activate Range(Cells(1, 1), Cells(5000, 1)).Select ActiveSheet.Paste The debugger does not give me any error at the statement -- sheet1.activate -- but neither it is activating sheet1, rather a sheet (sheet2)which is already active is selected and within sheet2's range (A1:A5000) the data is pasted. Why is it behaving like this? Either it should paste the data in Sheet1 or it should give me an error saying that a hidden sheet cannot be activated. Is there a logic for the present behaviour? (Pls. note I can programmatically unhide the sheet, do the desired copy, paste operation and then again hide it but my question is from understanding point of view) Thanks a lot, Hari India |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
Hidden page bracks in Excel should be deactivated | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
How do I unhide multiple sheets? | Excel Worksheet Functions |