How to choose a specific row among selected ones

[ref]

I want to choose a specific row among selected ones. Let's say i have a range of rows selected

Please Login or Register  to view this content.

If I use

Please Login or Register  to view this content.

It selects the 7th row in excel, thus row number 7 in excel, and not the 7th of my selection (number 11).
How is this sorted out?

[Winon]

Hi ref,

I don't think you can select within Select. Either you choose a chocolate, or an ice-cream!

[ref]

Hi ref,

I don't think you can select within Select. Either you choose a chocolate, or an ice-cream!

Then what's the solution? First maybe activate and then select that way?

[Winon]

One would normally Select a Range of rows to Update, Copy and Paste, or the like. When you need to address a certain row or Cell, that would be for a specific reason which may include referencing or calculations and so on.

In short then. Yes. Directly Select the specific Cell OR Row OR Range you need to work with seperately.

[ref]

Can't do that. I have multiple spreadsheets with time depended data. For a standard range i need to select a specific cell, with a userform interface. But the cell for the calculations comes from 5 combobox selections, so its not that simple like just making a code to select a cell.

[OnErrorGoto0]

If you have already selected the range, then just

Please Login or Register  to view this content.

though note that that is row 10, not 11.

[ref]

If you have already selected the range, then just

Please Login or Register  to view this content.

though note that that is row 10, not 11.

Worked, thx. Yes it is row 10, but I have an extra one for summing every 7 rows. Nice of you noticing.

[Winon]

@ 0EGO,

Wow!, so you can Select within Select.

@ ref

so its not that simple like just making a code to select a cell

Please could you upload a sample setup of your WorkBook. Maybe that will enable us to assist you better.