I indi visual Member Jul 22, 2011 #1 I've been using Sheet2.Visible = True, and then setting it back to False after I write the data. But is there any way to bypass the true false visibility statements?
I've been using Sheet2.Visible = True, and then setting it back to False after I write the data. But is there any way to bypass the true false visibility statements?
K kchiba Active Member Jul 22, 2011 #2 Hi, You can still write to t hiiden sheet. Sub test() Sheets("test").Visible = False Sheets("test").Range("A1").Value = 500 End Sub name a sheet "test" Set any cell on your any visible sheet to =Test!A1 run the above code and you ahould see the 500 appear on the visible sheet
Hi, You can still write to t hiiden sheet. Sub test() Sheets("test").Visible = False Sheets("test").Range("A1").Value = 500 End Sub name a sheet "test" Set any cell on your any visible sheet to =Test!A1 run the above code and you ahould see the 500 appear on the visible sheet
