Compile error: sub or function not defined
Hi,
I am trying to solve one classic problem. Say, there are some excel sheets available in one workbook. All the excel sheets are of same format (same column name but differnt data and number of rows). I want to merge these sheets into one. I'm using a macro but when I try to run it shows the Compile error: Sub or Function not defined and the second statement (Sub CopyData....) highlighted in yellow.
Please Login or Register to view this content.
Last edited by arlu1201; 08-17-2012 at 03:39 AM. Reason: Added code tags
@ Anita7
Welcome to the forum.
Please notice that code tags have been added to your post instead of the quote tags. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.
And your post has been moved from the Introduction area so that it will be seen by those who can offer assistance.
The lastrow function was not defined anywhere, hence the issue. This is your updated code -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The Function will be available where you got the code from i.e. Ron de Bruin's site
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you Arlete)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks