XL2BB Issue with table with formula.

HighAndWilder

Active Member
Joined
Nov 4, 2006
Messages
398
Office Version
  1. 365
Platform
  1. Windows
I am not sure if this issue should be raised elsewhere so please advise me if that is the case.

I have a sheet with one table with formula in many of the columns.

I highlight the table and select the Mini Sheet XL2BB option.

I get a error 6 Overflow error message.

The table contains formula but these are not included in the XL2BB code if I select the Table Only option.

Short of submitting VBA code that creates and populates a table how can I submit a table with formula in a post.

Thanks
 
@HighAndWilder: I got your file. Thanks for letting me analyze it.

Could you please check the named ranges in the workbook. I think you might have selected the entire worksheet to change the font but entered Arial into the name box. Therefore, it is considered as a named range (which is already the case) and XL2BB is failing due to the huge named range. If you delete the Arial named range, then everything should work without problems.
 

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

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
Back
Top