jmenche
09-06-2007, 08:41 AM
Howdy,
This is more of a rant than a request but I'll run this up the flagpole anyway. I am writing a routine that populates a worksheet. Every time I add or delete a column to the worksheet, I have to go into my routine and change allllllllllllllllll of the column references by hand :banghead: .
Is there anyway to automate this??? Too bad the VBE doesn't update like a formula does ;-)
Thanks for listening!
This is more of a rant than a request but I'll run this up the flagpole anyway. I am writing a routine that populates a worksheet. Every time I add or delete a column to the worksheet, I have to go into my routine and change allllllllllllllllll of the column references by hand :banghead: .
Is there anyway to automate this??? Too bad the VBE doesn't update like a formula does ;-)
Thanks for listening!