Paste by rows and blank cell problems

[mr starface]

Hello, new here and after some Excel/VB help

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

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

Thanks for any help people

 

[Tom Ogilvy]

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" <[email protected]>
wrote in message
news:[email protected]...