Guitarde Board Regular Joined Mar 18, 2003 Messages 238 Nov 29, 2005 #1 I usually use the following code to get the number of rows: Range("data").Select vNbRow = Selection.Rows.Count Is there a way to get this without any Select ...something like Range("data").Rows.Count (this is not working). Thanks Eric
I usually use the following code to get the number of rows: Range("data").Select vNbRow = Selection.Rows.Count Is there a way to get this without any Select ...something like Range("data").Rows.Count (this is not working). Thanks Eric
Norie Well-known Member Joined Apr 28, 2004 Messages 76,059 Office Version 365 Platform Windows Nov 29, 2005 #2 Eric How is it not working? Is this what you are trying? It seems to work for me. Code: vNbRow = Range("data").Rows.Count
Eric How is it not working? Is this what you are trying? It seems to work for me. Code: vNbRow = Range("data").Rows.Count