Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Arnold Scott   on Oct 24 In MS Office Category.

  
Question Answered By: Adali Fischer   on Oct 24

I added a description of what should be copied (the formula), and that
should do it, I think. Your code should check  for empty cells in Column
A just fine.

Public Sub CopyDown()
LastRow = Range("A65536").End(xlUp).Row
For i = 1 To LastRow
If Range("A" & i).Value = "" Then
Range("A" & i - 1 & ":CB" & i - 1).Formula.Copy Destination:=Range
("A" & i)
End If
Next i
End Sub

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on VBA help with data Or get search suggestion and latest updates.


Tagged: