Debug code

fizza94 · Apr 1st 2016

Hi,

I have a code that transposes information using a number tagging system. However, currently it is giving me an error: Run-time error '1004': Cannot change part of a merged cell.

Can you please help me debug the code? I have attached the excel file that I need to transpose, as well as the macro called 'transpose' within it.

Thank you!
Fiza

forum.ozgrid.com/index.php?attachment/68740/

**pike** · Apr 1st 2016

Re: Debug code

Hi
if the first value in column B is empty the code deletes the column
but if the next row has the same item number and values in column b it errors as the counters has progressed
first example row 66 item 28

fizza94 · Apr 2nd 2016

Re: Debug code

so what would be the best workaround for that? do i simply say SkipBlanks=True?

**pike** · Apr 2nd 2016

Re: Debug code

Its a merged cell on that line that stops the code
you could unmerge all cells in the worksheet and then run the code ..

Debug code

Participate now!

Share