Excel: Correct usage of Cells()


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 :/


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of June 04, 2017.


For more resources for Microsoft Excel