Hi Bob
he said that he wanted to "perform calculations on them", so i thought
giving him an example of adding would help :)
Cheers
JulieD
"Bob Umlas" wrote in message
...
That will ADD them. To SELECT them, try the following:
If your data is in A1:A100, enter 1 in B1, X in B2. Select B1:B2,
double-click the fill handle
Now with B1:B100 selected, use edit/goto special, select Constants,
deselect
all but "Numbers".
Now you have B1,B3,B5,... selected. Now go to VBA, and enter this in the
immediate window:
Selection.Offset(,-1),Select
and you have it!
Bob Umlas
Excel MVP
"JulieD" wrote in message
...
Hi
check out
http://www.cpearson.com/excel/excelF.htm#SumEveryNth
for ideas
Cheers
JulieD
"froot_broot" wrote in message
...
how can i select every other cell in a column? every nth cell? i have
a
bunch of data but only want to to perform calculations on some of the
points.