| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of Range please.
Hello from Steved
How do I tell this to drop down to the next cell meaning Range("A9").Select Sub CtrlD() Selection.FillDown Range("A9").Select End Sub I Thankyou. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Instead of Range please.
Can you give an idea of what the code is supposed to do?
If you are looking to move down on row from the where ever your active cell is, you can use this: ActiveCell.Offset(1, 0).Select Post back and let us know. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Steved" wrote: Hello from Steved How do I tell this to drop down to the next cell meaning Range("A9").Select Sub CtrlD() Selection.FillDown Range("A9").Select End Sub I Thankyou. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Instead of Range please.
Hello PJFry
This is exactly what I require. Thankyou Steved "PJFry" wrote: Can you give an idea of what the code is supposed to do? If you are looking to move down on row from the where ever your active cell is, you can use this: ActiveCell.Offset(1, 0).Select Post back and let us know. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Steved" wrote: Hello from Steved How do I tell this to drop down to the next cell meaning Range("A9").Select Sub CtrlD() Selection.FillDown Range("A9").Select End Sub I Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
| Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
| how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming | |||
Linear Mode
