Assigning cell reference value
I've created a variable (newName) and assigned a string value representing a cell reference [Worksheets("Members").Range("B2")]. I've constructed it this way because I wish to interate the row/col reference to step through a name listing. I've assigned an Object variable (strName) to extract the value from the cell newName, but its not working!! What am I missing??
Roger
Hi
I don't really understand your question. Can you post your code?
Assigning cell reference value
I see what you mean now...