I have a fill down to copy data to the last row of data. Currently, my spreadsheet has 437 rows of data. Data exists in A, B, C, D, E, F. For some reason, the macro is stopping at row 393. I checked rows 394 and beyond in column G and all columns are blank. Any idea as to why this is happening?
The DIM USDRWS....etc is in an earlier part of the macro so I don't have it listed above the portion of the macro I have included.
Dim UsdRws As Long
UsdRws = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Range("G2").Select
ActiveCell.FormulaR1C1 = "=RC[-2]&TEXT(RC[-1],"" MM/DD/YY"")"
Range("g2:g" & UsdRws).FillDown
The DIM USDRWS....etc is in an earlier part of the macro so I don't have it listed above the portion of the macro I have included.
Dim UsdRws As Long
UsdRws = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Range("G2").Select
ActiveCell.FormulaR1C1 = "=RC[-2]&TEXT(RC[-1],"" MM/DD/YY"")"
Range("g2:g" & UsdRws).FillDown