This is CRAZY i have this sub in my sheet(1), i copied to sheet 2 and am using it from a btn Click event. i get the errror :
Select method of range class failed
runtime error 1004 on the 2nd row "Range("A3").Select" is this because the sub is in sheet 1 and i want it to work with another sheet?
How can i call subs from this workbook, a modual from diff sheets? I konw it can be done just dont know how to qualify the sub
LastRow = ActiveCell.Row