Selecting cells in a row

[Jeff W.]

when rowcount = 3, I need to select cells A3 thru H3

when rowcount = 5, I need to select cells A5 thru H5

I have tried a few things, but I'm missing something

' rowcount count's thru the rows of a sheet I have

I have;

a_num = rowcount
h_num = rowcount

cells("a_num:h_num").select

This doesnt seem to work

Can anyone suggest somthing I could try?

Thanks

Jeff W.

 

[JW]

when rowcount = 3, I need to select cells A3 thru H3

when rowcount = 5, I need to select cells A5 thru H5

I have tried a few things, but I'm missing something

' rowcount count's thru the rows of a sheet I have

I have;

a_num = rowcount
h_num = rowcount

cells("a_num:h_num").select

This doesnt seem to work

Can anyone suggest somthing I could try?

Thanks

Jeff W.

Range(Cells(rowcount, 1), _
Cells(rowcount, 8)).Select

But, please keep in mind, is most situations, actual selection of
cells is not necessary. See your other post (link below) for an
example.
http://groups.google.com/group/micr...dc606308419/f32933ba40f978f7#f32933ba40f978f7

 

[Jeff W.]

This helped me get the one I was struggling with to work,
I am using your code from below, its half the size.

Thanks...

Jeff W.