Hi All!

So the "project":

In an Excel sheet I want to create a macro that jumps to a reference based on the value of a given cell.

sg like this:

Goto.Reference = "R" & [reference to the cell] & "C1"

only the number of row changes, column number is the same (always 1)

Do U have an easy solution for this?

Great many thanks in advance
sbgabor

Re: Goto.Reference in Excel with variable 80 80

Hi,
Assuming that the cell that will contain the row number is "A1" the code will be:

ActiveSheet.Cells(Range("A1"), 1).Select

Re: Goto.Reference in Excel with variable 80 80

Hi,
Assuming that the cell that will contain the row number is "A1" the code will be:

ActiveSheet.Cells(Range("A1"), 1).Select

It is that easy??

OMG...!! Many THX kb.net!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.