VBA Selection.Column

[Lara465]

Hello!

So I have something like this :

Dim selrow as string, selcol as string

I do an action an then I am in a specific cell and I write
selcol=Selection.Column
To keep the column number I was in

A do some other actions and I end up in another cell, this time I want tot keep the row of this current cell
celrow=Selection.Column

This is where I blocked. So I have a number in each selcol and selrow, is there a way to put them together? To tell to go select the Cell[celrow, celcol], so to use the celrow and celcolumn as a range.
Ex: if celrow = 2 and celcol= 3, to go and select the cell (2,3) ?

Thanks.

 

[Lara465]

I found the answear, If I declare then as Integer not String, I can call them by using Cells(celrow,celcol).Select.

 

[Fazza]

hi, Lara

Glad you sorted that out.

I suspect it is just a typing error, but just in case, where you've got "celrow = Selection.Column" should be "celrow = Selection.Row"

regards, Fazza