EAN/UCC-14 Barcode: set Excel column widths based on a cell value?

d · 01-11-2006, 12:20 PM

I'm trying to create EAN/UCC-14 barcodes using columns in Excel. I've figured
out a way to express the code in binary numeral strings. Now, If I could use
those numerals to set column widths, my problem would be solved. For example,
if C2=2, I'd like set the width of Column C to 2.0 Any ideas? Thanks

**arronlee** · 06-26-2014, 12:10 AM

Hi,
As for me, I am testing the related excel barcode add-in these days. Do you have any ideas about it? Or any good suggestion? I am totally a green hand on EAN/UCC-14 barcodes field. Any suggestion will be appreciated. Thanks in advance.

Best regards,
Arron

**allensmith** · 01-28-2015, 12:16 AM

Originally Posted by d

I'm trying to create EAN/UCC-14 barcodes using columns in Excel. I've figured
out a way to express the code in binary numeral strings. Now, If I could use
those numerals to set column widths, my problem would be solved. For example,
if C2=2, I'd like set the width of Column C to 2.0 Any ideas? Thanks

I also wonder how to set column width to a cell value.I have a macro that I need to change column width of cells depending on a cell value.
As in if cell a1 = 1.11, a2=2.22, a3=3.33, I want the width of column b to be changed to 1.11 (a1) etc..
The problem is that a1,b1 and c1 will constantly be changing which is why I cant just set the solumn width values in the macro.Thanks in advance for any help

HTML Code:

I need 31 for example to equal whatever value is in cell a1.

**sktneer** · 01-28-2015, 12:52 AM

@d

Welcome to the forum.
You will need a macro to achieve this. A formula cannot set the column width based on a cell value.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**sktneer** · 01-28-2015, 12:53 AM

Hi allensmith,
Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.