How can i define below start range as range given in a cell to do a Loop ?? Please help

**akash kothari** · 06-24-2015, 10:04 AM

How can i define below start range as range given in a cell to do a Loop ?? Please help

Means range given in cell "B5" and "C5" in sheet 2 I want to use in below code

So that I can loop like (For counter = startrng To endrng ) Is it possible?

.Range("Q" & counter).Value

Please Login or Register  to view this content.

**Arkadi** · 06-24-2015, 10:47 AM

I'm not sure I fully understand... but sounds like you want the first cell and last cell of a range to be in those cells and then run a macro that checks each of the cells in that range? Maybe something like this:

Please Login or Register  to view this content.

**akash kothari** · 06-24-2015, 11:50 AM

Hi Arkadi,

You got it right

and Thank you so much for your help.

Its working fine the only thing which I want to ask now how can I copy the range towards right to it from Actual Vs plan tab.
as of now I am using like this

If myCell.Value = Sheets("BurnMacro").Range("C3").Value Then
Sheets("Actual vs Plan").Range("R16:V17").Copy Destination:=Sheets("BurnMacro").Range("B8")

and will it Ignore the hidden rows in Actuals tab? (as I don't want to copy those)

Thank you
Akash

**akash kothari** · 06-24-2015, 12:35 PM

Hi Arkadi,

I think I got it (Just copied your code from the above

), not completely as it is copying the hidden row as well which I don't want to copy any suggestion how can we copy only visible rows ??

see the below code

Please Login or Register  to view this content.

**Arkadi** · 06-24-2015, 01:24 PM

Akash, well done although your code copies the whole range over and over this way... not just the row of one cell, so if one cell = C3 then it will copy all the range. Try

Please Login or Register  to view this content.

**Arkadi** · 06-24-2015, 04:00 PM

This is probably 1. Easier to follow, and 2.more effective, also fixed the issue of pasting the values in the same destination each time (my bad)

Please Login or Register  to view this content.

**akash kothari** · 06-25-2015, 12:05 PM

You are awesome. Thank you so much,

Akash

**Arkadi** · 06-25-2015, 12:25 PM

Happy to help akash, please mark the thread as solved if you are satisfied with the solution.

How can i define below start range as range given in a cell to do a Loop ?? Please help

LinkBack

Thread Tools

Rate This Thread

Display

How can i define below start range as range given in a cell to do a Loop ?? Please help

Re: How can i define below start range as range given in a cell to do a Loop ?? Please hel

Re: How can i define below start range as range given in a cell to do a Loop ?? Please hel

Re: How can i define below start range as range given in a cell to do a Loop ?? Please hel

Re: How can i define below start range as range given in a cell to do a Loop ?? Please hel

Re: How can i define below start range as range given in a cell to do a Loop ?? Please hel

Re: How can i define below start range as range given in a cell to do a Loop ?? Please hel

Re: How can i define below start range as range given in a cell to do a Loop ?? Please hel

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Define Range based on another Range loop

Define range to select from current cell in a full range (using worksheet_change)

Why did an inner loop variable start overwriting the outer loop range suddenly?

[SOLVED] Using cell value to define a range (for a variable defined as a range)

HOW CAN I DEFINE A RANGE IN LOOP

Bookmarks

Bookmarks

Posting Permissions