GOTO with Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ineed to use the GOTO instruction, but the name to put into the instruction
comes from a resulto of a concatenate function in one cell. Ejem: A1:"HR"
B1:"NOV", C1:"HRNOV"with a concatenate function.
After when I run de Macro I need to use this text "HRNOV" to put it into de
GOTO excel facility.
I don't know how to do this, because in the Macro always keep the first text
that I use when recorded the Macro.
 
Application.Goto Range(Worksheets("Sheet1").Range("C1")), True

assume HRNOV is a defined range on the worksheet.

and HRNOV appears in C1 of sheet1. If the code is in a sheet module and
HRNOV is not on that sheet, you would need to qualify the first Range with
the sheet name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Help 5
Changes Required In Macro Code 2
Text Box contents to cell comments 5
Duplicate "Drag" feature 2
Problem with macro 3
concatenation w/in a macro 2
Goto Last Cell function 1
keep source formatting when concatenating 1

Back
Top