Get Cell location in VB

[gplevritis1]

When i write my vb script and I use Sheet1.cells(i,1), how do i actually get the cell location ie if i=1 then it would be sheet1.cells(1,1) which would be location A1. i want to create a variable that actually is A1.

[Norie]

Something like this perhaps.

Please Login or Register  to view this content.