ExcelBanter - Counting Variable Length of Rows in a Named Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Counting Variable Length of Rows in a Named Range (https://www.excelbanter.com/excel-programming/315098-counting-variable-length-rows-named-range.html)

jandre[_3_]

Counting Variable Length of Rows in a Named Range

I just got an "Overflow" error on the line

totalrows
Range("Work_Total_Exp").Cells(Range("Work_Total_Ex p").Cells.Count).row

:confused

--
jandr
-----------------------------------------------------------------------
jandre's Profile: http://www.excelforum.com/member.php...fo&userid=1583
View this thread: http://www.excelforum.com/showthread.php?threadid=27323

All times are GMT +1. The time now is 06:01 PM.