Returning the value from Column A

[AndrewMB]

Morning all,

I'm using For Each cell in a particular column. If this value is greater than zero I need to pull in the value from column A. But the column I'm currently in will change based on which month it is. How do I return the value from Column A no matter what column I'm in.

ie. if I was always in the same column I could use offset, but the column Im in is variable.

 

[AndrewMB]

I think I got it... its early.

shtname = Cells(cell.Row, 1).Value