Member Avatar for [sbgabor]

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

  • 2 Contributors
  • 2 Replies
  • 91 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by [sbgabor]
Member Avatar for kb.net

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

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

Member Avatar for [sbgabor]

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.