1. C

    Finding the second empty row

    Hi, I have a code to copy and paste values till first empty row but then I want vba to copy and paste values after that till it find second empty row. So For first I did Lastrow = Cells.Find(What:="*", After:=[A20], SearchOrder:=xlByRows).Row Range("A1:H" & Lastrow - 1).Offset(19, 0).Copy...
  2. M

    How to get cells.find in other sheet?

    Dear Gents, I'm in sheet2, and I want use cells.find method to get the column number of sheet1 that contain specific words like "LogNo" Dim d, e As Long d = Cells.Find(what:="LogNo", After:=Sheet1).Row But it shows errors. Could you please help me to figure this out? Thanks.
  3. gheyman

    Copy Down to last Row

    How Do I get the formula to go down to the last Row? lastrow = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row lastcol = Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column + 1 'after last populated col lastcol2 =...
  4. W

    Help me make this dynamic

    Guys i have a piece of code (noted with the *) that repeats itself over and over for different columns. Range("D3").Select ActiveCell.FormulaR1C1 = "=Year(NOW())" If Cells(Rows.Count, "A").End(xlUp).Row > 3 Then *LR =...

Some videos you may like

This Week's Hot Topics