Dear all
I have written this formula to make a dynamic name range - define as "Master""
Picture2.png
=OFFSET($A$1,0,0,COUNTA($A:$A),COUNTA($1:$1))
Error message occurred,
Thanks
Dear all
I have written this formula to make a dynamic name range - define as "Master""
Picture2.png
=OFFSET($A$1,0,0,COUNTA($A:$A),COUNTA($1:$1))
Error message occurred,
Thanks
Hi,
he error shows something wrong with one of the field names but I can't see anything wrong from your screenshot.
I've tried to reproduce your error but i can't.
Would it be possible to share your file as attachement (of course filled with sample data)
HtH,
Joris
--------------------------------------------------------------------------------
If you found my answer helpful, please hit the Like or Thank button.
Please follow the forum Rules and Guidelines and use Code tags around your VBA code.
Remember: test VBA code always on a copy of your file because usually you can't use undo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks