#1
|
|||
|
|||
Fill Series
Is there a way to produce a fill series (e.g. Mon, Tue, Wed) using a keyboard shortcut?
|
#2
|
|||
|
|||
Just set a shortcut key to run a macro like this one:
instructions : http://www.bettersolutions.com/word/...C216621011.htm Sub LoopFillRange() ' Fill a range by looping through cells Dim CellsDown As Long, CellsAcross As Long Dim CurrRow As Long, CurrCol As Long Dim CurrVal As Long ' Get the dimensions CellsDown = 1 If CellsDown = 0 Then Exit Sub CellsAcross = 7 If CellsAcross = 0 Then Exit Sub ' ' Loop through cells and insert values CurrVal = 1 Application.ScreenUpdating = False For CurrRow = 1 To CellsDown For CurrCol = 1 To CellsAcross Range("A1").Offset(CurrRow - 1, CurrCol - 1).Value = CurrVal CurrVal = CurrVal + 1 Next CurrCol Next CurrRow ' Display elapsed time Application.ScreenUpdating = True End Sub |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select Series Color - Macro | judicial85 | Excel Programming | 0 | 03-14-2011 02:35 PM |
Data Series | Zach | Excel | 1 | 11-05-2010 02:45 PM |
Selecting specific text out of a series of columns | speedycorn1 | Word | 3 | 11-01-2010 02:58 PM |
Uniform color for scatter plot with 2 series | gramentz | Excel | 2 | 01-17-2010 08:21 AM |
Custom animating a line chart by series and category. | Gahzi | PowerPoint | 0 | 05-19-2009 11:53 AM |