M
MDTablet
I have a workbook that has several worksheets in it. Each worksheet contains
a range with the same name. This is used for finding a position in the
worksheet. Everytime I make a change to my vba code ( any of the vba code )
my routine that finds the cell address of the common named range fails only
on the first sheet in the workbook. All other sheets it finds the named
range. I have to recreate the range or the worksheet before it will work
again.
Any suggestions?
a range with the same name. This is used for finding a position in the
worksheet. Everytime I make a change to my vba code ( any of the vba code )
my routine that finds the cell address of the common named range fails only
on the first sheet in the workbook. All other sheets it finds the named
range. I have to recreate the range or the worksheet before it will work
again.
Any suggestions?