.
I know I need to reduce the following down into something more readable and manageable. Also, Excel doesn't very much like the size
of my macro because of it.
How would this be edited using RESIZE ?
Thank you !
Thanks for reading !
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
.
Mumps
Would you mind if I posted the workbook for you to review ?
I can't promise any solution, but I'll be happy to have a look.
.
Thank you Mumps !
Attached
Is the PopulatePMSheetFromQuery macro working for you as it is written? If it is working, I'm not sure what you want me to do. If it isn't working for you, how is it not working?
.
I receive an error message PROCEDURE TOO LARGE. It errors out at the end of the PopulatePMSheetFromQuery macro on END SUB.
Nothing gets populated to the Senior PM sheet.
From what I've read, PROCEDURE TOO LARGE means the macro is more than 64kb. I have to go out now. I will have a look at the macro tomorrow and get back to you.
.
Thank you. I'll be going out as well. Back in a few hours.
Hello Logit,
You will see from the pattern in the Code below, how to shorten your Code with Resize. do the remaining rows of the Module, and delete the lines that are commented out.
HTHPlease Login or Register to view this content.
Kind regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
.
Hey Winon ..
Thank you for looking at this.
The first thing I realized after making some adjustments to the size of the macro, was I had it backwards !DUH !
Then I changed the code to what you have posted as 'commented out' ... but still no go.
I've removed everything from the macro with the exception of the code lines you provided above. Regretfully it doesn't work.
No errors ... nothing gets written to the Senior PM sheet.
Looking online, there are plenty of sites that talk about the "ActiveCell.Row". I'm guessing that it the ticket but in what
'combination' with the remainder of the line of code ?
Plugging away here.....
.
Two other attempts that did not work :
Please Login or Register to view this content.
1. You have declared a variable, Activecell, which you should not have done since Excel/VBA has a keyword/property ActiveCell.
2. You declared it as a range variable but never set it so that it points to nothing....
Please Login or Register to view this content.no test for empty row?
Ben Van Johnson
For the left column.
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.
@ protonLeah and bakerman2,
You guys seem to enjoy evoking my temper.
Without my permission, you just jump in with excellent observations, and commendable solutions. Now let me warn you for the last time!
You guys ROCK!
Kudos to you!
@ Logit,
Glad you have your issue resolved. Unfortunately it had to be with the responses from two Gurus who I hold in great esteem.
Thank you for the Rep+. Much appreciated!
Regards.
Logit, glad to help and thanks for rep+.
If you have any questions regarding right column, feel free to ask.
.
bakerman2
Thank you for the offer. I have you all on my list for "go to's " when I need help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks