Hi Black, Did you find the solution is helpful.
Regards, Lalit Mohan On Monday, 31 December 2012 10:18:25 UTC+5:30, black panther wrote: > > Dear Prince, > > No same color, any color but light color, > > What i am looking for:- > > if cell A1 having yellow & B1 having blue then > > for 1500 time it need to change > > when loop run at that time A1 will be blue and B1 will yellow > > next > > A1 will be yellow and B1 will be blue and so on..... > > > > Thanks & Regards, > Prajakt Pande > +971551388482 > ** > > > On Mon, Dec 31, 2012 at 7:12 AM, Prince <prince...@gmail.com <javascript:> > > wrote: > >> Hi Prajakt, >> >> Please explain bit more so that i provide best solution from my end.like >> 1: do you need same color combination >> 2: and what do u mean by continuously. >> >> Regards >> Prince >> >> >> >> >> On Sunday, December 30, 2012 10:43:35 PM UTC+5:30, black panther wrote: >>> >>> Dear Prince, >>> >>> Good evening, that's right but it need to change continuously like loop >>> >>> Thanks & Regards, >>> Prajakt Pande >>> +971551388482 >>> ** >>> >>> >>> On Sun, Dec 30, 2012 at 7:38 PM, Prince <prince...@gmail.com> wrote: >>> >>>> Hi Friend >>>> >>>> PFA >>>> >>>> Regards >>>> PRINCE >>>> >>>> On Sunday, December 30, 2012 4:41:42 PM UTC+5:30, black panther wrote: >>>>> >>>>> Dear All, >>>>> >>>>> In advance Happy New Year. >>>>> >>>>> Attached a Excel sheet, in that i need to run a loop for changing cell >>>>> colour. >>>>> >>>>> For example :- >>>>> A coloumn colour to B coloumn, B to C, C to D, D to E, E to F, F to G, >>>>> G to H & H to A >>>>> >>>>> Thanks & regards, >>>>> >>>>> -- >>>> Join official Facebook page of this forum @ https://www.facebook.com/** >>>> discussexcel <https://www.facebook.com/discussexcel> >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To post to this group, send email to excel-...@googlegroups.com. >>>> To unsubscribe from this group, send email to excel-macros...@** >>>> googlegroups.com. >>>> Visit this group at >>>> http://groups.google.com/**group/excel-macros?hl=en<http://groups.google.com/group/excel-macros?hl=en> >>>> . >>>> >>>> >>>> >>> >>> -- >> Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-...@googlegroups.com<javascript:> >> . >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
