*Notices Olly has a blog*
Interesting...
*Goes to the site and sees the title "Using Merged Cells Effectively in Excel"*
"Well i really didn't think that was possible..... but if Olly says it is, I have to check this out..."
*Clicks on it...*
"Oh... "
"NEVER MERGE CELLS"
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
haha I like it!!
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
LOL!!!!!!!!!
It's a rite of passage: first you discover merged cells and find them attractive, then you are seduced by them and use them everywhere, then you realise they are cheating you by preventing you from analysing your data effectively, and finally you have to say 'goodbye'. I think most of us have been there ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Good reminder that I haven't posted anything useful in AGES....
So this morning I've finally started a series I've had in mind for a while, of sharing some basic Power Query tips and tricks that I've found particularly useful.
Fab - link, please!
@Olly,
It looks as if your site doesn't acccept comments.
e.g. the replacement of your turn columns into Text.
in VBA:
Please Login or Register to view this content.
Not sure I understand your post, snb?
Exactly what is says:
Your site doesn't accept comments.
https://excel.solutions/2019/07/powe...s/#comment-234
That's why 'recent comments' is so empty.
I got that bit. What's the VBA code?
Looks like my Shield anti-bot settings were falsely flagging EVERY comment as spam.
Are you simply suggesting a VBA method for the PQ function?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks