Hello All,
The following is some code I have put together to get a packing slip template I am building, to automatically copy some of the data once filled in over to an external workbook. This will allow our shippers to fill in the sheet and then have the external sheet be a running log of all completed packing slips. I keep getting "variable not defined".
Some help please
Please Login or Register to view this content.
Your missing this one.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
To help with things like this, put this at the top of the code module:
Then in the VBEditor, go to DEBUG > Compile VBAProject, it should highlight any undeclared variables for you.Please Login or Register to view this content.
When I did that it point out the RowCount variable is not listed in your Dims.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the help, but I am still getting an error indicating the subscript is out of range. My Packing slip template has 4 sheets whereas my example file I included only had 1. Could this cause the error?
subscript out of range in VBA (at least for me) is always an object I'm trying to address that is named incorrectly in my code or a variable. DEBUG and look at the highlighted line of code and spot the named objects (Sheet names, workbook names, object names) and variable in that line of code that are related to object names. The problem will be in there.
Hello Elliot...
Fantastic Journey you on...VBA rocks!!!
Play around with this slight simplification...Easy to understand...Baby steps
Put this code in Packing Slip Example and save file as a Macro Enabled File...
Change path to suite...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Still getting subscript out of range and it always highlights the current worksheet. Ill try to play around with it some more to see what is happening but if anyone else has any ideas...
TIP of the day: Sometimes when we name our worksheet tabs, we accidentally put an extra space at the end, invisible to the eye when done, but forever a "mismatch" when VBA tries to address sheets by name without that hidden space in the code. Worth a look.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks