worksheet delete reset

  1. B

    Setting the select all to select some

    I am working in Excel (not 2007) and am trying to get a Macro that will run and select all Cells in a Worksheet except for the first row. What I have so far is this: Dim LR As Long LR = .Cells(Rows.Count, 1).End(xlUp).Row + 1 Sheets("M").Activate Range("A2:T" & LR).Select...
  2. S

    (worksheet).delete method causes Project Reset !!

    Hi, I have encountered what seems like a very frustrating and stupid Excel vba bug. When I use the worksheet.delete method. My vba project is RESET. All forms object classes and variables disapear into the BIT BUCKET. Does any one have any ideas on what is causing, this, and wehter...

Some videos you may like

This Week's Hot Topics