I want to choose a specific row among selected ones. Let's say i have a range of rows selected
If I useRowRange = Range("4:4", "11:11").Select
It selects the 7th row in excel, thus row number 7 in excel, and not the 7th of my selection (number 11).Rows(7).Select
How is this sorted out?
Last edited by ref; 02-06-2012 at 12:29 PM.
Hi ref,
I don't think you can select within Select. Either you choose a chocolate, or an ice-cream!
Please consider:
Be polite. Thank those who have helped you. Click the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Then what's the solution? First maybe activate and then select that way?Originally Posted by 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.
Please consider:
Be polite. Thank those who have helped you. Click the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
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.
If you have already selected the range, then just
though note that that is row 10, not 11.selection.rows(7).select
Good luck.
Worked, thx. Yes it is row 10, but I have an extra one for summing every 7 rows. Nice of you noticing.
@ 0EGO,
Wow!, so you can Select within Select.
@ ref
Please could you upload a sample setup of your WorkBook. Maybe that will enable us to assist you better.so its not that simple like just making a code to select a cell
Please consider:
Be polite. Thank those who have helped you. Click the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks