Macro changing text to "?/??" format???

**adam2308** · 08-28-2009, 07:27 AM

I have the code below in a macro which seemed to work fine but somehow it manages to convert cells in text format into "?/??" format when the macro is run. This bit relates to the part of the code highlighted in red below... Any questions please ask, this is causing me major problems and need to fix it asap. I've attached a copy of the workbook if it helps. Unfortunately, to run the macro you will need to change the file directory to one that will suit.

Please Login or Register  to view this content.

**adam2308** · 08-29-2009, 12:47 PM

Could i possibly bump this thread up... Any suggestions would be greatly appreciated.

**shg** · 08-29-2009, 01:06 PM

The code is pasting whatever format is in the copied cells. If you just want to paste values, change Paste:=xlPasteValuesAndNumberFormats to Paste:=xlPasteValues

**adam2308** · 09-11-2009, 11:31 AM

Sorry for only just replying on this, got busy with something else...

I can't paste just the values with this as this would only work the fractions 4/6 and 6/4, other fractions would paste the numeric value i.e. 7/4 would paste 1.75 and i need to keep it to the fractional format.

I have tried to replicate the macro manually (without deleting all the rows that column A is blank) and it works ok but won't work when using the macro button.

**adam2308** · 09-11-2009, 03:41 PM

Can anyone help with this or am i not making myself clear enough? Like i said earlier you may need to setup 3 csv files and alter the file directory in the VBA to suit to see the macro work for yourself.

**adam2308** · 09-13-2009, 08:51 AM

Can anyone help?

Thanks.

**adam2308** · 09-13-2009, 05:51 PM

I've just found out (by trial and error) that if i delete this portion of the red code above, the 4/6 remains as 4/6 and does not round down to 2/3.

Please Login or Register  to view this content.

As far as i know this code should simply delete any rows where the column is blank. I don't understand how it would affect the rest of the code whether it was in the macro or not?

Any help please?