Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |