Select till row destination

[prabhubox@yahoo.com]

Hi Friends,

I am using the below code to select the column range which is equal to column A

Similarly I want to modify this code to convert in to row destination i.e. I want to make first row (1,1) as constant and when I need to select any of the row it should be equal to the numbers of cell in the first row.

Request you help in modifying the below code in to row destination.

Please Login or Register  to view this content.

Regards,
Prabhu

[NeedForExcel]

Not very clear what is required..

Request you to clarify!

[prabhubox@yahoo.com]

Ex. I need to select row no3 with the same number of cells to row no 1

if row 1 has date from A1 to H1 i want to select row 3 also form A3 to H3

The VBA code which is mentioned to help to select column equal to Column "A" similarly i want to design for rows as well

[NeedForExcel]

MayBe

Please Login or Register  to view this content.