| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VISUAL BASIC COMMAND TO MOVE CURSER DOWN ONE CELL
Can Anyone Tell me Please the Command to Move the Curser One Cell Down from
Any Cell as a Stating Point to Any Other Cell Without Using the Command for Example - "Range ("A1") .Select" as this limits me to selecting this one cell only. I need to Write a Formula That Will Find a Number in a Row Based on a No. in One Perticular Cell. My Idea is To Move Down a Cell at a time within a List of No.s and Loop Until the Found Cell Matches the No. in a Reference Cell i.e. "Move Down Until = A1" or "move Down One Cell at a time, End When Cell = A1" I'm sure you get the gist of what I'm After, Please Help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VISUAL BASIC COMMAND TO MOVE CURSER DOWN ONE CELL
Selection.Offset(1,0).Select
-- Gary's Student "Moving Problem!" wrote: Can Anyone Tell me Please the Command to Move the Curser One Cell Down from Any Cell as a Stating Point to Any Other Cell Without Using the Command for Example - "Range ("A1") .Select" as this limits me to selecting this one cell only. I need to Write a Formula That Will Find a Number in a Row Based on a No. in One Perticular Cell. My Idea is To Move Down a Cell at a time within a List of No.s and Loop Until the Found Cell Matches the No. in a Reference Cell i.e. "Move Down Until = A1" or "move Down One Cell at a time, End When Cell = A1" I'm sure you get the gist of what I'm After, Please Help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VISUAL BASIC COMMAND TO MOVE CURSER DOWN ONE CELL
Thank-you very Much, This Does the Trick, I Shall Look Out for More of Your
Answers to Problems in the Future Thanks Again Gary's Student, Marcus. "Gary''s Student" wrote: Selection.Offset(1,0).Select -- Gary's Student "Moving Problem!" wrote: Can Anyone Tell me Please the Command to Move the Curser One Cell Down from Any Cell as a Stating Point to Any Other Cell Without Using the Command for Example - "Range ("A1") .Select" as this limits me to selecting this one cell only. I need to Write a Formula That Will Find a Number in a Row Based on a No. in One Perticular Cell. My Idea is To Move Down a Cell at a time within a List of No.s and Loop Until the Found Cell Matches the No. in a Reference Cell i.e. "Move Down Until = A1" or "move Down One Cell at a time, End When Cell = A1" I'm sure you get the gist of what I'm After, Please Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a dymanic formula to a cell using visual basic | Excel Discussion (Misc queries) | |||
| excel formula - possibly visual basic method | Excel Discussion (Misc queries) | |||
| Visual basic macro move cursor down 1 cell | Excel Worksheet Functions | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Linear Mode
