select range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geebee - 21 Nov 2007 15:21 GMT

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

Reply to this Message

Dave Peterson - 21 Nov 2007 15:36 GMT

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

> hi,
>
[quoted text clipped - 11 lines]
> thanks in advance,
> geebee

Signature

Dave Peterson

Reply to this Message

geebee - 21 Nov 2007 16:15 GMT

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

> try
> cells(17,x).select
[quoted text clipped - 16 lines]
> > thanks in advance,
> > geebee

Reply to this Message