WorksheetFunction.Count
That works, Thanks
"Trevor Shuttleworth" wrote: Jim try: ActRow = ActiveCell.Row rng = WorksheetFunction.Count(Range("K" & ActRow & ":AT" & ActRow)) Regards Trevor "Jim at Eagle" wrote in message ... ActRow = ActiveCell.Row rng.Value = WorksheetFunction.Count(Range("K" & ActRow : "AT" & ActRow)) I tried many variations and recieve error "Expected: List seperator or )" Solution sought, dreamed of, and wished for Thanks -- Jim at Eagle |
WorksheetFunction.Count
You're welcome. Thanks for the feedback.
"Jim at Eagle" wrote in message ... That works, Thanks "Trevor Shuttleworth" wrote: Jim try: ActRow = ActiveCell.Row rng = WorksheetFunction.Count(Range("K" & ActRow & ":AT" & ActRow)) Regards Trevor "Jim at Eagle" wrote in message ... ActRow = ActiveCell.Row rng.Value = WorksheetFunction.Count(Range("K" & ActRow : "AT" & ActRow)) I tried many variations and recieve error "Expected: List seperator or )" Solution sought, dreamed of, and wished for Thanks -- Jim at Eagle |
All times are GMT +1. The time now is 06:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com