Copy sequentially down list to every other row in another sheet

**eonizuka** · 02-22-2010, 05:20 PM

If someone doesn't mind, what I'd like to do is to use loops to copy each value in "Sheet1" into every other row in column B of "Sheet2" starting on row 16. I realize that this is a simple task, but I'd like to know how to do this for the purposes of learning the correct VBA coding.

**Palmetto** · 02-22-2010, 05:38 PM

One way to go about it

Please Login or Register  to view this content.

**eonizuka** · 02-22-2010, 05:59 PM

Thank you for the help with this.

**eonizuka** · 02-22-2010, 07:11 PM

Also, if you don't mind, I'd like to set the font color to red, font to bold, and cell borders to thin. I spent about 40 minutes attempting to do this but am having trouble with the syntax...

**Palmetto** · 02-23-2010, 08:29 AM

I'd like to set the font color to red, font to bold, and cell borders to thin

Code amended in previous post per the above.

**eonizuka** · 02-23-2010, 03:28 PM

Hi again Palmetto,

Sorry to butcher your code, but where am I going wrong here? I'm receiving an "invalid or unqualified reference" error in the Set Rng line on the .Cells object. I'm attempting to set from B1 to the last row in column B as the range.

Please Login or Register  to view this content.

**Palmetto** · 02-23-2010, 05:49 PM

Please Login or Register  to view this content.

**eonizuka** · 02-23-2010, 06:58 PM

Thanks again for the help. When I become well-to-do from flipping foreclosures I'll remember those kind souls who have helped me out in my quest to make office work a little less tedious. I'll start making offers on properties this week. So have your paypal accounts ready this time next year! If not, I'll probably still be on these forums asking inane questions.