| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select last cell in Selection
I am trying to write some VBA to use the row number of the last cell
in selection as a variable. How do you set this as a variable? Thanks, Jay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select last cell in Selection
Const whatColumn as String = "A"
Dim lastrow lastrow = Range(whatColumn & Rows.Count).End(xlUp).Row "jlclyde" wrote: I am trying to write some VBA to use the row number of the last cell in selection as a variable. How do you set this as a variable? Thanks, Jay |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select last cell in Selection
Hi
myrow = Selection(Selection.Count).Row Mike "jlclyde" wrote: I am trying to write some VBA to use the row number of the last cell in selection as a variable. How do you set this as a variable? Thanks, Jay |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select last cell in Selection
On Jun 27, 3:04*pm, Mike H wrote:
Hi myrow = Selection(Selection.Count).Row Mike "jlclyde" wrote: I am trying to write some VBA to use the row number of the last cell in selection as a variable. *How do you set this as a variable? Thanks, Jay- Hide quoted text - - Show quoted text - Mike H. , That is way too simple. I am glad I know that now. Thank you for that. Jay |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select last cell in Selection
Your welcome and thanks for the feedback
Mike "jlclyde" wrote: On Jun 27, 3:04 pm, Mike H wrote: Hi myrow = Selection(Selection.Count).Row Mike "jlclyde" wrote: I am trying to write some VBA to use the row number of the last cell in selection as a variable. How do you set this as a variable? Thanks, Jay- Hide quoted text - - Show quoted text - Mike H. , That is way too simple. I am glad I know that now. Thank you for that. Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| how to select fewer cells without canceling original selection | Excel Discussion (Misc queries) | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| I do not see the selection colour when I select some cells | Excel Discussion (Misc queries) | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
Linear Mode
