I am using the below macro, how can i avoid using select? I have seen / heard that .Select is not good to use.
Please Login or Register to view this content.
I am using the below macro, how can i avoid using select? I have seen / heard that .Select is not good to use.
Please Login or Register to view this content.
Last edited by jdcortez; 02-04-2019 at 10:35 PM.
Here's something good to read...
http://www.tushar-mehta.com/excel/vb...acro_recorder/
I didn't test this, but you should be able to...
This...
To this...Please Login or Register to view this content.
Because of this...Please Login or Register to view this content.
I would say this is unnecessary...Please Login or Register to view this content.
But again, I have not tested thisPlease Login or Register to view this content.
HTH
Regards, Jeff
Unfortunately that did not work, I uploaded a copy of a sample WB with my macro so you can see what I am trying to achieve.
You seem to be asking the macro to work very hard to do something very simple.
does this do what you want?
Please Login or Register to view this content.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
I am laughing at how simple your effective solution is. Was overthinking it way too much! Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks