Using Cells notation

[azizrasul]

I have the following snippet of code:-

Selection.LinkedCell = "H" & x

However I have a loop where next time around the code will be:-

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?

 

[VoG]

Possibly

Selection.LinkedCell = Cells(X, icolumn).Address

 

[schielrn]

Maybe a 2nd counter? or using offset?

You would need to post your current code because it is hard to work with what you have, but probably something similiar to:

Selection.LinkedCell = cells(x,y).address(0,0)

Hope that helps.

 

[azizrasul]

Selection.LinkedCell = Cells(X, icolumn).Address did the trick. Many thanks.

 

[azizrasul]

Sorry to trouble you guys again, but I have another similar problem i.e.

                .Range("H" & x).Select
                .Range("H" & x).Value = True

I have the above code again running in a loop, where checkboxes are set to True or False i.e. H1, H2, H3, I1, I2, I3, J1, J2, J3, etc.

 

[schielrn]

You should be able to do the same as above. With that example you would have 2 loops, one for rows going 1 to 3 and one for columns going 8 through 10.

Expande the columns and rows loop numbers as needed.

 

[VoG]

There is no need to Select (and it slows your code down). Try something like

Cells(X, icolumn).Value = True

 

[azizrasul]

Thanks Peter, I didn't think it was that simple.