GOTO with Macros
 

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.

GOTO with Macros
 

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.

--
Regards,
Tom Ogilvy

"PBallia" wrote in message
...
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.