Hi,
I'm writing a macro that pastes a row of data from one sheet to another. FYI, the original row of data is in a list.
What happens is that when I paste the row onto another worksheet, Excel merges the row below with my selected row. I don't want it to do that. If I do it manually, it works fine... If I do it with a macro, it merges then pastes it in.
Thanks in advance.
I'm writing a macro that pastes a row of data from one sheet to another. FYI, the original row of data is in a list.
What happens is that when I paste the row onto another worksheet, Excel merges the row below with my selected row. I don't want it to do that. If I do it manually, it works fine... If I do it with a macro, it merges then pastes it in.
Thanks in advance.