Forum Discussion

JMKnox's avatar
JMKnox
Copper Contributor
Jan 18, 2023

How to apply changes only to active rows when writing a macro

I am trying to write a macro which will insert a few blank columns and then insert specific values into the new columns (one example is simply inserting the letter "C"). This is easy to do manually, ...
excel
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
Jan 18, 2023

JMKnox 

For example:

Sub Test()
    Dim LastRow As Long
    Application.ScreenUpdating = False
    LastRow = Cells.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    Range("D1:F1").EntireColumn.Insert
    Range("D1:F" & LastRow).Value = "C"
    Application.ScreenUpdating = True
End Sub
Shiming's avatar
Shiming
Copper Contributor
Jan 30, 2023
Hi Hans, sorry it might sound idiot but can you tell me what subject I should learn in order to write these languages? Thanks.