Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim active sheet
Can I add a DIM line for this macro?
It seems I need to access the complete sheet. If I have to many cells it will not work correctly. With fewer cells it works fine Sub Cell_Down() ' ' Cell_Down Macro ' Macro recorded 2/25/2009 by Windows User ' ' Keyboard Shortcut: Ctrl+d ' Selection.Insert Shift:=xlDown End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim active sheet
Hi,
There's nothing to Dimension in this code, it will simply insert as many cells as you have selected. What is/isn't it doing that you want it to? Mike "Stanley Braverman" wrote: Can I add a DIM line for this macro? It seems I need to access the complete sheet. If I have to many cells it will not work correctly. With fewer cells it works fine Sub Cell_Down() ' ' Cell_Down Macro ' Macro recorded 2/25/2009 by Windows User ' ' Keyboard Shortcut: Ctrl+d ' Selection.Insert Shift:=xlDown End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim active sheet
Why not just do
Cells.ClearContents -- __________________________________ HTH Bob "Stanley Braverman" wrote in message ... Can I add a DIM line for this macro? It seems I need to access the complete sheet. If I have to many cells it will not work correctly. With fewer cells it works fine Sub Cell_Down() ' ' Cell_Down Macro ' Macro recorded 2/25/2009 by Windows User ' ' Keyboard Shortcut: Ctrl+d ' Selection.Insert Shift:=xlDown End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim active sheet
Sometimes I need to move cells down only several cells and at other times I
might need to move them down 30 or more cells. That's why I need individual control of move cells. "Bob Phillips" wrote in message ... Why not just do Cells.ClearContents -- __________________________________ HTH Bob "Stanley Braverman" wrote in message ... Can I add a DIM line for this macro? It seems I need to access the complete sheet. If I have to many cells it will not work correctly. With fewer cells it works fine Sub Cell_Down() ' ' Cell_Down Macro ' Macro recorded 2/25/2009 by Windows User ' ' Keyboard Shortcut: Ctrl+d ' Selection.Insert Shift:=xlDown End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim active sheet
Then why do you feel that you need to access the whole sheet?
-- __________________________________ HTH Bob "Stanley Braverman" wrote in message ... Sometimes I need to move cells down only several cells and at other times I might need to move them down 30 or more cells. That's why I need individual control of move cells. "Bob Phillips" wrote in message ... Why not just do Cells.ClearContents -- __________________________________ HTH Bob "Stanley Braverman" wrote in message ... Can I add a DIM line for this macro? It seems I need to access the complete sheet. If I have to many cells it will not work correctly. With fewer cells it works fine Sub Cell_Down() ' ' Cell_Down Macro ' Macro recorded 2/25/2009 by Windows User ' ' Keyboard Shortcut: Ctrl+d ' Selection.Insert Shift:=xlDown End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating new sheet named one week newer that active sheet | Excel Programming | |||
active sheet is 'slow' to be active | Excel Programming | |||
I need to sort an active sheet using the col of the active cell | Excel Programming | |||
Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming |