How do you select a cell and select another cell, without un-selecting the first cell? I'm trying to select many cells within a loop.
2007-11-16 11:23:14 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
You really shouldn't ever be selecting cells within a macro. It is bad programming and is far less efficient. What exactly are you trying to do within this loop that you would need to select cells? Try this site, it is very helpful:
http://www.mrexcel.com/board2/index.php
Hope that helps some, but it would be nice to know what exactly you are trying to do to offer better assistance?
But to answer your question specifically you could accomplish this by:
Range("A1,A5,B7,C7,C5,C2").Select
2007-11-19 04:20:25 · answer #1 · answered by Robert S 3 · 0⤊ 0⤋
If you are using the macro recorder just hold down the control key while selecting the other cells. Otherwise it's best to just define the range or transfer the values you want to an array.
2007-11-18 23:06:05 · answer #2 · answered by devilishblueyes 7 · 0⤊ 0⤋
Select the first cell, hold down the control key, then select the second cell.
2007-11-16 11:37:31 · answer #3 · answered by mrs_doctor_jones 3 · 1⤊ 0⤋