select range

[Guest]

hi,

i have the following:

dim x as integer
for x = 1 to lastcol
columns(x).select
next x

i would like to know ifthere is some way i can select a particular range
instead of the whole column... like how can i amend the preceding to simulate
selecting H17? sorta like range(H17).select

thanks in advance,
geebee

 

[Dave Peterson]

try
cells(17,x).select
instead of
columns(x).select

 

[Guest]

hi,

thanks... so now i would lke to take the code further by changing the
conditional formatting dynamically also...
i now have...
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLessEqual,
Formula1:="=round(h17,3)<=$G$17.

so would i change the preceding to...
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLessEqual,
Formula1:="=round(x & 17,3)<=$G$17.

am i onthe right track?

thanks in advance,
geebee