Excel pastes in the same orientation as when you copied the cells. If you
want to change that, then do edit=Paste Special and select Transpose.
Turn on the macro recorder while you do it manually to get code if that is
what you need.

sounds like you have a formula in the cells that returned "" such as

=if(true,"","")

if you copy that and do a paste special values, then cell appears empty, but
isn't.

You can do

with ActiveCell
.value = .value
end with

--
Regards,
Tom Ogilvy


"mr starface"
wrote in message
...

Hello, new here and after some Excel/VB help:)

I need to past special some data by rows and by default excel pastes by
coloumns. Anyone know the command to paste by rows? (or even better the
code for VB as its needed for a macro)

Also I have a number of cells that have no data or spaces in them but
are not recognised by excel as being blank for some reason. If I
manually go into them one by one and press F2 then return they then
become blank though Anyone know some excel/VB code I can use to get
them recognised as blanks. They arent all in one place unfortunately
but all over the shop!

Thanks for any help people!


--
mr starface
------------------------------------------------------------------------
mr starface's Profile:
http://www.excelforum.com/member.php...o&userid=30520
View this thread: http://www.excelforum.com/showthread...hreadid=501731