GOTO with Macros

P

PBallia

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.
 
T

Tom Ogilvy

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.
 
Top