Excel Visual Basic to get current row number

M

mattsonnier

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
 
G

GS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VB to capture the current cells row number 4
Excel VB to create and send an outlook appointment with html code 1
I need help with this program written in Visual Basic for Excel 2007. 4
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Word How to get 'current line number' in Word VBA 0
Displaying large number of pictures in EXCEL 1
Insert row 2
Excel and Visual Basic 2

Top