i have the following macro that works, note that the activecell's are named ranges (1 cell) found on the "navigation (2)" sheet
now here is the button macro that fails on range d9, what it does is copy from a template, name it, then put in values from the navigation sheet.
Please Login or Register to view this content.
can someone explain why its not working as expected?Please Login or Register to view this content.
Hi,
Purely from the code I can see nothing obvious. WOuld you upload the workbook so that we may test in context.
We can also simplify the code considerably. You don't need all the .Select stuff.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
uploaded it now. i deleted the sheet named "a". so go to the navigation (2) page, find A and press the Add button to the right. then it fails with a 1004 error. please don't laugh how i coded this sheet, i can only program what i know how to do, so im sure there is better ways to implement the Add's and Deletes.
i appreciate the help richard, thanks.
Create 1.xlsm
Using your current code you need
However much better would bePlease Login or Register to view this content.
End SubPlease Login or Register to view this content.
that worked, wish i had your brain, life would be so much easier. one gold star for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks