shorter way of writing things

[hitch_hiker]

G'day all,
can i replace

Range("c10").Select: ActiveCell = ""

with

Range("c10").value = ""

I think the answer is yes , but I'm not sure

 

[VoG]

Yes.

 

[hitch_hiker]

thanks Peter

 

[Hermanito]

I'd like to elaborate a little bit on VoG's very short and totally correct answer

The answer is (imho) not so much that you can do it like that, but that you should do it like that. In almost all cases, there is no need for the .Select code that often originates from recording stuff.
Performance and reliability of your code will be much higher without using Select.

Just my 2 cents

 

[hitch_hiker]

thanks Hermanito

does it really affect performance that much, I have created this code by recording , plagiarising , and asking for modifications, so far it has worked

I thought what you said was the case

 

[VoG]

You may find this helpful http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm

 

[hitch_hiker]

Thanks Peter, I had a cusory glance at it, I will definately read it when I get home, as you said it looks like what I need

 

[Hermanito]

if you are only working with a few cells, you won't notice a big difference in performance, but if you need to work with larger ranges (thousands or tens of thousands of cells), you will definitely see a very big difference, especially if you need to loop through the range cell per cell and perform some actions or checks...