How Can I Avoid Using .Select in VBA?

**jdcortez** · 02-04-2019, 09:35 PM

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.

**jeffreybrown** · 02-04-2019, 09:41 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...

Please Login or Register  to view this content.

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 this

**jdcortez** · 02-04-2019, 10:36 PM

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.

**scottiex** · 02-04-2019, 11:19 PM

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.

**jdcortez** · 02-04-2019, 11:28 PM

I am laughing at how simple your effective solution is. Was overthinking it way too much! Thank you!!

Re: How Can I Avoid Using .Select in VBA?