VBA Paste

ent1701e · Mar 20th, 2002, 09:27 AM

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.

Al Chara · Mar 20th, 2002, 10:37 AM

Try the following code:

Worksheets(2).Rows("1:1").Value = Worksheets(1).Rows("1:1").Value

It sets Row 1 of Worksheet 2 equal to Row 1 of Worksheet 1. If you give me more details of exactly what you want to do, then I customize the macro for you.

Mar 20th, 2002, 10:37 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following code: Worksheets(2).Rows("1:1").Value = Worksheets(1).Rows("1:1").Value It sets Row 1 of Worksheet 2 equal to Row 1 of Worksheet 1. If you give me more details of exactly what you want to do, then I customize the macro for you. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 09:27 AM	#1
ent1701e New Member Join Date: Mar 2002 Posts: 2	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.