S serge Jan 16, 2004 #1 Hi, I need to activate the first empty cell in a column. Can someone help me?
L Loomah Jan 16, 2004 #2 you could use range("a1").end(xldown).offset(1,0).activate for cells in column A You could also use range("a65536").end(xlup).offset(1,0).activate depends on your data ;-)
you could use range("a1").end(xldown).offset(1,0).activate for cells in column A You could also use range("a65536").end(xlup).offset(1,0).activate depends on your data ;-)
L lennon Jan 16, 2004 #3 -----Original Message----- Hi, I need to activate the first empty cell in a column. Can someone help me? Click to expand... Put cursor on any data in cell and then SHIFT+END, SHIFT+Arrow down.
-----Original Message----- Hi, I need to activate the first empty cell in a column. Can someone help me? Click to expand... Put cursor on any data in cell and then SHIFT+END, SHIFT+Arrow down.
