Hey guys,
So I'm new to this forum and extremely new to VBA/Macro's. Ive spent the past week searching for a solution to this error and after reading countless threads I still can't seem to figure out my specific problem. Any help would be amazing and thanks in advance! Here's a portion of the code along with where the error message gets put up.
Please Login or Register to view this content.
Last edited by mbie451; 08-11-2014 at 02:28 PM.
can you attach a sample file ?
If solved remember to mark Thread as solved
The goal I had was to use the dataCL and dataSW worksheets as a way to input rolling data that would update the main template worksheet. It first convert the range into a table, average everything out, and then reconvert it back into a range
I actually realized my problem with the original post but now have run across another problem. Every time I click the button that is attached to the macro it changes the table name from LiftUpdater to LiftUpdater_1, LiftUpdater_2, etc. and wont recognize the rest of the code associated with the original table name. Is there any way to lock in the table name so it doesn't change?
Hi, mbie451,
please have a look at Forum Rule #3 and add code-tags to your procedure from the opening post.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine 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