smithan04
05-12-2011, 08:29 AM
I am trying to use a macro to change row numbers 5451,5452,5453,5454,5455,5456,5457,5458,5459,5460,5461,5462,5463,5464,5465, 5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480, 5481,5482,5483,5484,5485,5486,5487,5488,5489,5490,5491,5492,5493,5494 (set 1) to
9051,9052,9053,9054,9055,9056,9057,9058,9059,9060,9061,9062,9063,9064,9065, 9066,9067,9068,9069,9070,9071,9072,9073,9074,9075,9076,9077,9078,9079,9080, 9081,9082,9083,9084,9085,9086,9087,9088,9089,9090,9091,9092,9093,9094 (set 2)
The second set of numbers will continue to change per worksheet. Currently, I have a macro with a bunch of search and replace code. Surely, there is a better way.
Thanks,
Annette
9051,9052,9053,9054,9055,9056,9057,9058,9059,9060,9061,9062,9063,9064,9065, 9066,9067,9068,9069,9070,9071,9072,9073,9074,9075,9076,9077,9078,9079,9080, 9081,9082,9083,9084,9085,9086,9087,9088,9089,9090,9091,9092,9093,9094 (set 2)
The second set of numbers will continue to change per worksheet. Currently, I have a macro with a bunch of search and replace code. Surely, there is a better way.
Thanks,
Annette