I am trying to use Union for the first time and I guess I am not getting it as the Macros fires but nothing happens
ThanksPlease Login or Register to view this content.
Please Login or Register to view this content.
I am trying to use Union for the first time and I guess I am not getting it as the Macros fires but nothing happens
ThanksPlease Login or Register to view this content.
Please Login or Register to view this content.
Have you tried stepping through the code in debug manner? This will allow you to see each step and determine where the code is failing.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi there,
it looks like the start of IF is missing... Can You check that?
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Sorry ignore me :o)
Last edited by nathansav; 05-22-2014 at 09:34 AM.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
I had two things wrong and neither was the Union
LR = Range("A" & Rows.Count).End(xlUp).Row to get the last row of the visible range
This LR = Range("A" & Rows.Count).SpecialCells(xlCellTypeVisible).End(xlUp).Row only evaluates to 1?
And yes I was missing the beginning of my if which is a UDF
Now all is working fine
Thank yon all for the help
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks