Hi
I am trying to copy unique values from Transaction to Dashboard via VBA and function UniqueValue() which I am calling from Workbook_Open() but getting error We can't do that to a merged cell. Another problem is it triggers another function before completing UniqueValue()
Last edited by grcshekar; 09-26-2023 at 09:27 AM.
Try replacing your function with this to allow the code to complete without triggering other functions: not sure what is going on with the 'merged' cell message since there are none within those ranges....
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Hello @grcshekar.Take a look at this topic, maybe it will help you resolve your issue. Extract texts from list A to list B
This is fine but the error We can't do that to a merged cell. and unable to copyOriginally Posted by Bernie Deitrick
Try replacing your function with this to allow the code to complete without triggering other functions: not sure what is going on with the 'merged' cell message since there are none within those ranges....
Please Login or Register to view this content.
Didnt work
It's probably easier just to remove the pair of merged cells and make them look merged by adjusting the text wrap and left alignment.
There are no merged cells
There are on the DashBoard sheet.
G2:H2
N3:O3
A51:H51
Oops ! Thank you it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks