create control button and assigning it a macro
1. I am trying to write a new macro to create a control button in the first cell of the first empty column not already populated by a previously created control button.
2. Then I want to assign the new control buttons to already existing macros
im currently using: Set LastCol = Range("A1").End(xlToRight)
to find the last unused column, but it does not register the exisiting buttons as populating the cells and i get an error
"run-time error 1004: application-defined or object-defined error" likely because the cells do not contain regular data
any and all help is welcome. thanks
Re: create control button and assigning it a macro
Welcome to the forum.
Please can attach your Excel file as it will be easier and will let us experiment with your data, formulas, and code.
1. Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
2. Mark your thread [SOLVED] if you received your answer.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1