Selection in a range.
Hi
I am extremely new to Excel programming (this morning) and have had some
macro designs thrust upon me.
I am trying to select rows 1 & 2 of a previous selection (to effectively
format the header rows in table).
I have made it work where the table is 3 columns using:
Selection.Range("A1:C2").Select
but I need to make it work for tables more than 3 colums, the tables could
be any size and anywhere on a worksheet. So I tried:
Selection.Range("1:2").Select
but this didn't work.
Any suggestions?
|