puppawinnie
New Member
- Joined
- Dec 9, 2002
- Messages
- 11
I am using Excel 97 and I have written a macro will be applied to a number of spreadsheets with same formats but varying column lengths. Is there a bit of code that XL 97 will recognize as the end of a column that I can replace in my Macro(eg instead of Range (A2:A89)(for argument sake) so that each worksheet will see this as the end of column and I won't have to manually change that line for each spreasheet?