View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff W. Jeff W. is offline
external usenet poster
 
Posts: 38
Default Selecting cells in a row

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.