Forum Home
Press F1
 
Thread ID: 5693 2000-09-09 23:28:00 XL ? 2 different results with same macro Guest (0) Press F1
Post ID Timestamp Content User
6275 2000-09-09 23:28:00 XL ? 2 different results with same macro
I use the same macro instruction in two different spreadsheets to select the next empty cell in Column A.
In one spreadsheet Im left with the empty cell/row in mid-screen (good), in the other, the same cell/row is selected, but its way off screen, only becoming visible when I start entering data or use the arrow keys.

I don?t understand how I get two different results with the same macro, which is

Auto_Open
=Select (?R1C1?)
=Select.End(4)
=Select(?R[1]C?)
=End

This in Excel - Office 95

Thanks in anticipation?.John
jhw@xtra.co.nz
Guest (0)
1