LinkBack URL
About LinkBacks
Control Font size with spinner button, but if cell has no data font size is default to 12.
Control Font size with spinner button, but if cell has no data font size is default to 12.
Last edited by zplugger; 02-06-2016 at 08:07 PM.
Try:
Please Login or Register to view this content.
Last edited by Olly; 02-06-2016 at 09:58 AM.
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...
Thanks Olly, works like a champ.
Just ran into a problem,should of been more clearer on workbook. What if I have two cells merged? Works perfect on a single cell,sometimes I have two cells merge,is there a work around for this?
Best advice for merged cells: never merge cells.
Just got it working I changed
Please Login or Register to view this content.
Ouch still not working,I must use merged cells.
Getting Closer,but if I have a merge cell it will not read cell size. need a fix so if target cells count is greater then 1 it will work.I can change the 1 to 3 and it works sometimes but get a lot of errors.
When I change to a 3 I get Invalid use of a null?
Please Login or Register to view this content.
As much as I agree with Oily's "Never merge cells", you might want to look at the .MergeArea property of a cell.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks