Me and lists logic, we’ll never be friends…
So I’ve been trying to wrap my brain around this for the last hour straight…
The goal is to format multiple cel ranges on different sheets in excel.
My gut says it’s something about the list levels and the lacing but I’ve tried multiple combinations and can’t seem to figure it out… I’ve also tried chopping the list with sheet names to become the same list structure as the cell ranges but that hasn’t gotten me any further either…
I’ll also attach the script with some testing values…
BB Style multiple ranges on multiple sheets.dyn (28.3 KB)
I’m still getting nowhere, anyone any ideas?
Hi @Laura_BIMChick are you sure your excel sheets name is right…works great here…
Yes they are correct, but I see you used flatten on your list with the cell ranges…
I need the first sublist with cell ranges in the first sheet, and the second sublist with cell ranges in the second sheet…
I added the script with the test values in my original post…
arhhh ok think its jusst some lacing and list level
That’s also what I’m thinking, but I can’t seem to figure it out.
I’ve tried multiple combinations, but I think I’m to close to it.
Thought I might get a fresh look from someone new 
I will give it a take later…little bit busy right now ,) yes think you are very close…
1 Like
Hi @Laura_BIMChick… hmmm very strange…I just give it a test, thats the way i could get to work on multiple sheets…give it a try and see if this could work…
Can you share the script? The screenshot is a little blurry, and I can’t seem to replicate it correctly…
Yes sure…try something here it could work…
BB Style multiple ranges on multiple sheets.dyn (31.4 KB)
2 Likes
