smozgur

XL2BB - Excel Range to BBCode 2.0

No permission to download

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

6diegodiego9

Board Regular
Joined
Jan 9, 2018
Messages
50
Office Version
  1. 2016
Platform
  1. Windows
Hi smozgur and thanks for the great add-in!
However, with my usual workbook, even if I add a new blank sheet and try the "Mini Sheet" on a random range with just some random static "ABC" text, it hangs forever (without any error).
On a new workbook, it works.
Can I please send you my workbook via private message so that you can test it?

Thank you so much!
D.
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,343
Hi smozgur and thanks for the great add-in!
However, with my usual workbook, even if I add a new blank sheet and try the "Mini Sheet" on a random range with just some random static "ABC" text, it hangs forever (without any error).
On a new workbook, it works.
Can I please send you my workbook via private message so that you can test it?

Thank you so much!
D.
Hello, D

I started a conversation with you. That would be great if you could upload your workbook on the cloud and share the link with me.

Thanks.
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,343
Hi smozgur and thanks for the great add-in!
However, with my usual workbook, even if I add a new blank sheet and try the "Mini Sheet" on a random range with just some random static "ABC" text, it hangs forever (without any error).
On a new workbook, it works.
Can I please send you my workbook via private message so that you can test it?

Thank you so much!
D.
Thank you for reporting this issue.

The merged cells are not only a problem for the entire Excel ecosystem but also a big problem for the XL2BB add-in. We had a similar issue with data validation vs merged cells except it certainly has no solution. Now, looking at this one and it looks like XL2BB could handle this problem with a proper fix (although it is not actually XL2BB's fault).

Until the update, you can disable Named Ranges in XL2BB options to generate XL2BB mini-sheets in this particular workbook that contains named ranges in the merged cells (Sample range: Tools!B15).


Notes for development:
Handle merged cells in the named range.
 

6diegodiego9

Board Regular
Joined
Jan 9, 2018
Messages
50
Office Version
  1. 2016
Platform
  1. Windows
Wow, thank you very much smozgur for finding and hopefully fixing the problem! :)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,151
Messages
5,623,058
Members
415,949
Latest member
mcrandall99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top