VBA Selection Count

[slinkyjib]

Good morning all,

I'm trying to count the number of rows in a selection

lngLastRow2 = Selection.Count

Am I missing something from this?

Later in the code I do this..

Range("A" & lngLastRow2).Select
    ActiveSheet.Paste

 

[ADAMC]

Can you explain a little more? Are you saying your code doesnt work?

One way to count rows in a selection

Sub Count()
mycount = Selection.Rows.Count    'Change Rows to Columns to count columns
MsgBox mycount
End Sub