Run a Macro in multiple selected columns
Closed
RGPX
-
11 Nov 2010 à 13:14
data_encoder Posts 13 Registration date Wednesday 3 November 2010 Status Member Last seen 15 November 2010 - 12 Nov 2010 à 17:57
data_encoder Posts 13 Registration date Wednesday 3 November 2010 Status Member Last seen 15 November 2010 - 12 Nov 2010 à 17:57
Related:
- Run a Macro in multiple selected columns
- Tweetdeck larger columns - Guide
- How to make multiple selections in photoshop - Guide
- Excel run macro on open - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete columns in word - Guide
1 response
data_encoder
Posts
13
Registration date
Wednesday 3 November 2010
Status
Member
Last seen
15 November 2010
1
12 Nov 2010 à 17:57
12 Nov 2010 à 17:57
Highlight the range of cells you want the macro to run.
Sub FillAllBlanks()
Dim oRng As Range
Set oRng = Selection
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "=R[-1]C"
oRng.Copy
oRng.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
