Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Visual Basic to get current row number
I have an excel spreadsheet with 40 columns and 200 rows. Part of my code is below. How do I write the line sEndRow = sRange.Row to correctly get number 10, if my curosr is in cell H10?
Thanks in advance, Matt Sub Welcome_Note() Dim sRange As Range Dim sEndRow As Integer Dim sFirst_Name As String Dim sLast_Name As String sEndRow = sRange.Row sFirst_Name = ActiveSheet.Range("AA" & sEndRow) sLast_Name = ActiveSheet.Range("AA" & sEndRow) sFull_Name = sFirst_Name & " " & sLast_Name End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Visual Basic to get current row number
Already answered in the other forum you posted to.
In future, please do not multi-post; cross-post instead so answers in any forum also display in all forums posted to. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and its Visual Basic IDE | Excel Programming | |||
Programmatic access to visual basic project via Visual FoxPro | Excel Programming | |||
Excel and Visual Basic | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |