Changing ranges of code

**rhudgins** · 03-15-2011, 12:59 PM

I would like to change the entire code so each range will include data from column O. I tried to change the ranges below but I am not sure how to edit the entire code. Can anyone help? Thanks

Please Login or Register  to view this content.

Entire Code

Please Login or Register  to view this content.

**pike** · 03-16-2011, 05:43 AM

Hi rhudgins
consider.. union eg.

Please Login or Register  to view this content.

**pike** · 03-16-2011, 07:03 AM

but looking at the sub it maybe better to add two loop to handle the number increase in the ranges and have these two loops run another sub routine.
I'll have a close look tomorrow.

**rhudgins** · 03-16-2011, 11:37 AM

I am not sure how to incorporate your suggestions into my code. I appreciate your help.

**pike** · 03-16-2011, 09:23 PM

I was thinking along these lines

Please Login or Register  to view this content.

**rhudgins** · 03-17-2011, 10:06 AM

What would the final complete code look like? I tried making changes without success.

**pike** · 03-18-2011, 12:55 AM

rhudgins
with limited information about what you are doing ...try using

Please Login or Register  to view this content.

**snb** · 03-18-2011, 04:16 AM

There seems to be a pattern in your ranges.
So no need (even the contrary) do define all those 'constants'.

Please Login or Register  to view this content.

**rhudgins** · 03-18-2011, 11:11 AM

The final code is not working properly. The values in the ranges in column J should be copied to column A on the Tkr Consolidation worksheet and the values in the ranges in column O should be copied to column B on the Tkr consolidation worksheet. Right now the code is copying column J but not copying column O.

I tried changing this part but it is causing the code to copy a duplicate of column J to column A&B on the Tkr Consolidation sheet.

Please Login or Register  to view this content.

Any ideas what I am doing wrong?

**pike** · 03-18-2011, 04:16 PM

Hi rhudgins

This is way to complicated for what you need.but if you want to keep the range constants so it eaiser for you to select ranges thats ok

but just to copy the ranges to the target work sheet

Please Login or Register  to view this content.

**snb** · 03-18-2011, 04:42 PM

you can't copy non-contiguous ranges.

Please Login or Register  to view this content.

**rhudgins** · 03-18-2011, 04:53 PM

Thank you. This was over my head and you really helped me out.

**pike** · 03-18-2011, 05:21 PM

@sbn
you will find

Please Login or Register  to view this content.

will copy the two ranges

**pike** · 03-18-2011, 05:28 PM

rhudgins

run the code below and it will add the ranges to the first empty cell in target sheet

Please Login or Register  to view this content.

and we can work from there

**snb** · 03-18-2011, 05:35 PM

@Pike

Ok.
My suggestion is using only very basic high school arithmetic.

**teylyn** · 03-19-2011, 05:21 AM

Originally Posted by snb

[...]

Please keep in mind that I never give solutions, only suggestions.

[...]

...............................

Changing ranges of code

LinkBack

Thread Tools

Rate This Thread

Display

Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Re: Changing ranges of code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions