switters_aka
Board Regular
- Joined
- Oct 26, 2010
- Messages
- 118
can anyone help me with the following which is probably really simple but it's driving me mental. I am using the find function to establish the row number in a spreadsheet for an edit process.
the cells in Range("B:B") are linked to another worksheet. If I copy paste values on the cells in Range("B:B") the code above works a treat. Any ideas?
Code:
wks.Range("B:B").find("something").Row
the cells in Range("B:B") are linked to another worksheet. If I copy paste values on the cells in Range("B:B") the code above works a treat. Any ideas?