LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating new sheet named one week newer that active sheet davegb[_2_] Excel Programming 6 March 25th 08 12:21 AM
active sheet is 'slow' to be active Charlie Excel Programming 1 December 31st 07 06:33 AM
I need to sort an active sheet using the col of the active cell HamFlyer Excel Programming 3 June 6th 06 07:25 PM
Copy my active sheet to a new sheet and open with an input form Brad Withrow Excel Programming 0 April 6th 06 03:56 AM
Copy from active sheet and paste into new sheet using info from cell in active Ingve Excel Programming 3 January 23rd 06 09:57 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"