fredrerik84
Active Member
- Joined
- Feb 26, 2017
- Messages
- 383
Hi I hope some of you that are more experienced then me can help me with the correct usage of cells()
In my code I have it like this
Cells(z, "AM")
Where Z is an counter , this works perfect , but if I want the counter on the column instead , what do I need to do
I have this solution, Cells(21, z) which works but would be better that I could use column letter instead of 70 as its hard to tell (for me where column number 70 is.
I have tried this: Cells("M", z) but this gives an error :/
In my code I have it like this
Cells(z, "AM")
Where Z is an counter , this works perfect , but if I want the counter on the column instead , what do I need to do
I have this solution, Cells(21, z) which works but would be better that I could use column letter instead of 70 as its hard to tell (for me where column number 70 is.
I have tried this: Cells("M", z) but this gives an error :/
Last edited: