simoncpage
Programmer
Hi, this is a simple example, I have a sheet with ranges (in columns)
Range_a1...to...Range_a250
Range_b1...to...Range_b250
..
Range_z1...to...Range_z250
(where 250 is the maximum number of rows showing - this could be anything from 1 to 250)
each row is link to its own sheet tab. What I want to do is to be able to delete a row and which is fine. But when I run functions loops 'for i = 0 to 123' then this messes up if a number of the rows have been deleted (say for instance if the row 14, 15, 16 had been deleted).
Any ideas on how to get round this. I initally worked on a shift values about but then this involves changing the values on the corresponding tabs which just got messy.
Any ideas would be appreciated
Thanks
Simon
Range_a1...to...Range_a250
Range_b1...to...Range_b250
..
Range_z1...to...Range_z250
(where 250 is the maximum number of rows showing - this could be anything from 1 to 250)
each row is link to its own sheet tab. What I want to do is to be able to delete a row and which is fine. But when I run functions loops 'for i = 0 to 123' then this messes up if a number of the rows have been deleted (say for instance if the row 14, 15, 16 had been deleted).
Any ideas on how to get round this. I initally worked on a shift values about but then this involves changing the values on the corresponding tabs which just got messy.
Any ideas would be appreciated
Thanks
Simon