azizrasul
Well-known Member
- Joined
- Jul 7, 2003
- Messages
- 1,304
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
I have the following snippet of code:-
However I have a loop where next time around the code will be:-
and so on. How do I change the right side of the code and use the Cells notation to do what I want?
Code:
Selection.LinkedCell = "H" & x
However I have a loop where next time around the code will be:-
Code:
Selection.LinkedCell = "I" & x
and so on. How do I change the right side of the code and use the Cells notation to do what I want?