I know how to write the standard dynamic range that expands down:
But I want my range to expand across and not down, I tried
=offset($A$1,0,0,,counta($1:$1)) but it's not working ????
Any thoughts on this??
Puzzled in Connecticut...