This is my current code to unwrap text for a given range
I would like to build in a IF function to say if the given range is unwrapped (Cells.WrapTEXT = False) THEN wrap the range (Cells.WrapTEXT = True)
Please Login or Register to view this content.
i.e. everytime the macro button is clicked it will wrap and unwrap the data range
Last edited by Gti182; 03-26-2014 at 09:21 AM.
Will ALL of the referenced cells ALWAYS have the same wrap settings (all-wrapped...none-wrapped)?
Try this...
EDIT: ...if "yes" to Ron's question.Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
yes they will all be consistently formatted i.e. all wrapped or all unwrapped
AlphaFrog that works great! thanks
Try:
Please Login or Register to view this content.
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...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks