S sri.guru New Member Jul 30, 2014 #1 VBA:Next to worksheet("sheet1").range("a1") , here range is not coming automatically in 2007, to come the propery automtacilly what should i do
VBA:Next to worksheet("sheet1").range("a1") , here range is not coming automatically in 2007, to come the propery automtacilly what should i do
Hui Excel Ninja Staff member Jul 30, 2014 #2 worksheet("sheet1").range("a1") is a fixed reference to Sheet!A1 what do you mean by Automatically ?
S sri.guru New Member Jul 31, 2014 #3 so after the worksheet("sheet1"). i need the range,cells or activ cell appearing after the dot i.e not coming
so after the worksheet("sheet1"). i need the range,cells or activ cell appearing after the dot i.e not coming