Selecting cells based on current cells selected?

It seems I might have to use my 'ugly' workaround to delete rows in Excel 2002 (to preserve my forumulae in a column).

In order to do this I could use some help in code that would select Col A:G.

Here's the idea. If the cursor is on cell C28, then select cells A28:G28.
Similarly, if the cursor is on any cell in the A:G range.
So if the cursor is on cell B32, then select cells A32:G32.
Or if the cursor is on cell F45, then select cells A45:G45.

Also for multiple row selection, if the cursor is highlighting
cells C30, C31, C32, then select cells A30:G30, A31:G31, A32:G32.

Or if the cursor is highlighting cells C30, C31, C32, and D30, D31, D32
then also select cells A30:G30, A31:G31, A32:G32.

This will be the first step in my macro.

Do you mean

Please Login or Register  to view this content.

?

Changed slightly

Please Login or Register  to view this content.

See the code in Sheet1 code module.
Right click on sheet1 sheet tab - [View code]

Originally Posted by jindon

Changed slightly

Please Login or Register  to view this content.

See the code in Sheet1 code module.
Right click on sheet1 sheet tab - [View code]

Yes your code works very nicely. Thank you!
I will just have to figure out a way to combine it with a button, so that other
steps can follow after the selection has been made.

But I think I can build upon this!
More tomorrow.

Thanks very much jindon for your help!
I have been able to find a solution to my problem.