I'm trying to define a dynamic range on my VBA code, but every time I try to execute it I get this message: "vba application-defined or object-defined error".
Its been 2 days that I'm trying to solve it but everything I tried didnt make it work.
Error name: "Run-time error '1004': Application-defined or object-defined error"
Last edited by pedropradi; 05-02-2022 at 11:55 AM. Reason: Removed the picture and saved the macro
What is Alertas1
Sheet is called Alerta1
Or If Active Sheet then just...
Please Login or Register to view this content.
Anyway...see top yellow banner regarding file upload...Please Login or Register to view this content.
Last edited by sintek; 05-02-2022 at 09:19 AM.
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!!!
Thank you for directing me to read the yellow banner. I've corrected my post and "Alerta1" in the macro, but seems like it was not the problem.
Thanks for file...Your method of getting last row and last column is incorrect...
Why not just...
Also...RULE NO 1 of Excel...Never use merged cells...Please Login or Register to view this content.
Last edited by sintek; 05-02-2022 at 09:40 AM.
Didnt understand, sorry im new.
But, with this method will I be able to change the range dinamically?
Look at attached...I got rid of all merged cells and unnecessary rows and columns..
Please Login or Register to view this content.
Last edited by sintek; 05-02-2022 at 10:11 AM. Reason: Updated File
Wow thank you!
With this method, can I send the sheet in the e-mail?
Now this requires a bit more detail...Send sheet how...
As an attachment...
As an image attachment...
As image in body of email...
Its possible to send this sheet as a image in the body of email?
Here you go...
Wow this is amazing. I can't thank you enough. THANK YOU THANK YOU THANK YOU!!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Glad to have helped...Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks