Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting handle to Row # dynamically
Hello Experts,
1. I let the user select a range by foll code. Dim Rg As Range On Error Resume Next Set Rg = Application.InputBox(prompt:="Select range", Type:=8) If Rg Is Nothing Then MsgBox "Operation Cancelled" Else Rg.Select End If 2. User selects a row, for example say Row 10. 3. I want to perform a calculation on ColumnG and ColumnH of Row 10 (starting from row # 10 till end of value in columns G and H) 4. How will I get handle to column G and column H of Row 10. Thanks in advance Regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting handle to Row # dynamically
startrow=Rg.row
lastrow=Cells(rows.count,"G").end(xlup).row HTH "Prakash" wrote: Hello Experts, 1. I let the user select a range by foll code. Dim Rg As Range On Error Resume Next Set Rg = Application.InputBox(prompt:="Select range", Type:=8) If Rg Is Nothing Then MsgBox "Operation Cancelled" Else Rg.Select End If 2. User selects a row, for example say Row 10. 3. I want to perform a calculation on ColumnG and ColumnH of Row 10 (starting from row # 10 till end of value in columns G and H) 4. How will I get handle to column G and column H of Row 10. Thanks in advance Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is keyboard shortcut equivalent to drag the fill handle | Excel Discussion (Misc queries) | |||
Fill Handle | Excel Discussion (Misc queries) | |||
Fill handle formula | Excel Worksheet Functions | |||
Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions |