If i run a macro delete the rows for specific values then it is effecting my named range too. like if i delete
value at cell N2 for range "=OFFSET(Data!N2,0,0,COUNTA(Data!$N:$N),1)" then it is giving me #Ref error for that cell in named range - "=OFFSET(Data!#REF!,0,0,COUNTA(Data!$N:$N),1)". So how can i set N2 for evrytime automatically rather doing it manually every time.
Hello tanvi_kalra,
Easy. Just Place your Named Range on another Sheet, problem solved.
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
But i need that named range for that particular sheet only.. and need to use it again and again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks