- Hot Topics
Excel copy down info
I have a vb that I got it work in other workbook and sheet. But I am trying to use it on a new worksheet and it will not work. Can some help me with it or give me a formulas that will do the same thing. Code: Sub Dim Dim varData For i = LBound(varData, 1) + 2 To UBound(varData, 1) If IsEmpty(varData(i, 1)) Then '// Cell is empty. Copy value from above. varData(i, 1) = varData(i - 1, 1) End If Next i '// Write result to sheet. Sheet1.Range("B2").Resize(UBound(varData, = varData End Sub
This question generated 23 answers. To proceed to the answers, click here.
This thread is current as of April 18, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel