I am about to lose my mind on this one.
I am generating simple code through a macro and want to use it in a button. All I want to do is make a copy of a sheet and then select some fields to make simple modifications. The following is a simplified rep of the code where I run into a problem:
Sheets("Step 4 - Funding Request Form").Select
Sheets("Step 4 - Funding Request Form").Copy After:=Sheets(13)
Range("H2:BX3").Select
Selection.ClearContents
Range("H4").Select
Anytime I try to select a range of cells, I get an error. If I run as a macro it works fine, but when I put the code into a button, it fails.
PLEASE HELP!! This is driving me crazy....Thanks a lot
Bookmarks