Hi,
I want to select the bottom cell in a column.
Define a range in the format Top to bottom cell.
Paste Values into the cells
' Column L contains date values. In I2 input values based on Column L in
' format MONTH/2006
Range("I2").Select
ActiveCell.FormulaR1C1 = "=CONCATENATE(MID(RC[3],5,3),""/2006"")"
Range("I2").Select
Selection.Copy
Dim i As Integer
Dim c As Range
' Searches for the bottom occupied cell in the Column I
i = Cells(9, 1).End(xlDown).Row
Debug.Print (i)
' This returns 350
' I need to do the below dynamically
' Range("I3:I350").Select
' So I tried the following but both of the below formats error out.
' Range("I3:I(i)").Select
Range(Cells(9, 3), Cells(9, i)).Select
ActiveSheet.Paste
Please suggest ways to do this.
TIA
Ramakrishnan
Bookmarks