Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit Macro for GOTO Part No.
I'm using Sebastienm's solution to "GOTO a Part Number" Works Great, But once
I get to the part number I want to goto the current quarter (QT1, QT2, QT3, QT4) and edit/add the Recd1, Recd2, Recd3, Recd4 in that cell. Thanks for the Help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit Macro for GOTO Part No.
Hi,
Could you please be more specific? When the row is found , say it is store in the range variable Rg , what should the macro do? just go to the another column on the same row? -say Rg has been found -instead of going to that cell, say you want to go 3 cells (columns) on the right. Add the following line of code before the Goto method. Set Rg=Rg.Offset(0,3) Regards, Sebastien "RSB" wrote: I'm using Sebastienm's solution to "GOTO a Part Number" Works Great, But once I get to the part number I want to goto the current quarter (QT1, QT2, QT3, QT4) and edit/add the Recd1, Recd2, Recd3, Recd4 in that cell. Thanks for the Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit Macro for GOTO Part No.
It should go to another column named either Recd1, Recd2, Recd3, or Recd4 in
the same row as Rg. Maybe even ask what quarter to enter data? Then edit the active cell.(F2) and loop back to enter the next Part No. Thanks, RSB "sebastienm" wrote: Hi, Could you please be more specific? When the row is found , say it is store in the range variable Rg , what should the macro do? just go to the another column on the same row? -say Rg has been found -instead of going to that cell, say you want to go 3 cells (columns) on the right. Add the following line of code before the Goto method. Set Rg=Rg.Offset(0,3) Regards, Sebastien "RSB" wrote: I'm using Sebastienm's solution to "GOTO a Part Number" Works Great, But once I get to the part number I want to goto the current quarter (QT1, QT2, QT3, QT4) and edit/add the Recd1, Recd2, Recd3, Recd4 in that cell. Thanks for the Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GoTo macro... | Excel Discussion (Misc queries) | |||
goto function in macro 2 | Excel Discussion (Misc queries) | |||
Using 'GoTo' in a Macro | Excel Discussion (Misc queries) | |||
How do I edit a formula as part of a macro? | Excel Discussion (Misc queries) | |||
GOTO a Part Number | Excel Programming |