Copying rows to another worksheet

**solidgold10287** · 08-21-2007, 10:44 AM

Hello all,

I had a question about excel macros and VBA. So I have a sheet of raw data within an excel workbook. I already created a macro to create new worksheets. What I want to do is iterate through the raw data and depending on a value in a certain column, I want to copy that row to another worksheet. I think I know the beginning and the end, but I cant figure out how to iterate through the rows.

Any help would be much apprecieated.

Thanks!

**boylejob** · 08-21-2007, 11:24 AM

solidgold10287

Maybe something like this would get you started.

Please Login or Register  to view this content.

**solidgold10287** · 08-21-2007, 01:51 PM

Thanks for the quick response. This is what I have but for some reason it keeps throwing this error:

Run-time error '9':
Subscript out of range

It happens right when I try to set wsDefense equal to Sheets("Sheet2"). What am i doing wrong?

Please Login or Register  to view this content.

I also tried to do wsDefense = Sheets("Defense"), but for some reason i get this error:

Run-Time error '91':
Object variable or with block variable not set

I dont know where to go from here on either of these problems.

Thanks

**boylejob** · 08-21-2007, 02:02 PM

solidgold10287,

I apologize I was a little to quick with my response. I left the work "Set" off of my response.

These

Please Login or Register  to view this content.

all need the word Set in front. For example

Please Login or Register  to view this content.

Make that change and see what happens. Sorry for the error.

**solidgold10287** · 08-21-2007, 02:04 PM

Ahh thank you. Works like a charm

**solidgold10287** · 08-21-2007, 02:06 PM

One more thing, how would I access a certain column. I dont know the syntax. I'm assuming it would be something like:

lRow.Columns(index of column needed)

I've been looking but I cant find much on it.

**boylejob** · 08-21-2007, 04:19 PM

solidgold10287,

I'm not sure I understand your question. What do you mean by access a certain column? Do you mean you want to look at a specific cell on each row as you are looping thru. In other words, are you wanting to look at the value in column G of whatever row you are on.

If this is what you are wanting to do then any of these would reference a particular cell on the row (lRow) you are on.

Please Login or Register  to view this content.

If this does not help, be a little more specific and I'll see if I can give you a better answer.

Copying rows to another worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Copying rows to another worksheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions