Search results

Hello sir, Is there any way to find out solution for this problem.

sir, is there any way to store firstAddress = c.Address where c.Address is corresponding minimum date value of col G from a group of YES values in col D.

Hello sir, With reference to my uploaded workbook some problem arise. http://www.2shared.com/file/8ckVr-6J/11a.html sir we write function FindAll for discontinuous values.In my workbook row 8 & 9 has both same value of Col D & E, but row 9 has smaller date value so it want to push up to the...

Sir, when i run this macro again & again it show error Object Variable or With block variable not set.

@Luke M Hello sir, Last hurdle in front me. In my workbook, i want to add another criteria that relevant data filter in ascending order. Adding in these codes. 'Filter down to just the relevant info based on col G ActiveSheet.Range("A1").AutoFilter Field:=7, Criteria1:= _ "<=" &...

Hello SirJB7, I uploaded a file could you check it. http://www.2shared.com/file/3VPAry2d/colr.html

Hello bobhc, is it ok to change the row color after enter anything to row. If not then how many cells you want to color before data was entered.

Here is sample it may help. http://www.2shared.com/file/Tz4NiSPb/colr.html

Hi bobhc, Can i know where the problem occur, because i already use this code & it run fine.

Sir, I just came across a article about how to Undo Changes Done By Excel VBA. Here is referance http://www.jkp-ads.com/Articles/UndoWithVBA00.asp Is it possible to use it in all VBA to undo things that already happened. sir thank you for your kindly support.

woooo............ Its really a huge one. 'Function from Chip Pearson After this line all code are go over my head. I think i am asking a little, but seems am asking a lot. I can only say thank you sir, no other words.

Sir, i am working on reformulate the code & if it does give any solution then i will give you some trouble, asking it again. Next time i will ask my requirement with clean explanation. Again thank you sir for your help.

@SirJB7 Sir,Your code is absolutely correct & works as you describe. I only extend my requirement a little bit more,my appolige for that & want to how cell will also move if selected cell is below color cell. I will try & back if it is not done.

@Luke M, Hello sir, Again a small flaw was found. if i inserted a row then it gave problem in sorting. Here in uploaded file when i inserted row 14 it gives problem.I figure out that due to insert of May month after june month date it gives error.The same thing if i inserted after row 9 it...

Hello sir, Yes it do the trick,but only upwards is there any way to move the cell downwards. Thank you very much for your help sir. Now i learn something about how to Undo Changes Done By Excel VBA. Here is referance http://www.jkp-ads.com/Articles/UndoWithVBA00.asp does it do the...

@ SirJB7, Hello sir Thank you for your help.It is quit long in term of code written, it take some hard work to do it. Thanks again. Sir it only move color cells column not entire row & it moves only if the cell selected above the color cells.

Sir, if we store cells in array ascending order will it do the trick ?

Sir, we can omitted case 2 as it not necessary. I think if we can store colored cells in an array then inserted to the cell below activate cell i.e. activecell.offset(1,0) then it will produce the result.

hello sir please check uploaded workbook. http://www.2shared.com/file/My-qVhu7/SEQ.html

Sir its my fault that i can't explain it properly. After using code it works as when cursor on 2 , and run the macro the colored cells are immediately under the active cell But problem is when color cells move to under the active cell cell 3 do not just push down two places below , it move...

Hello NARAYANK991 sir, did you find out the solution to my problem.

He deserves that.

I used NARAYANK991 code which is in above post.

Hi Debraj Roy, http://www.2shared.com/file/ReYHgRyX/color.html if you look at the above workbook when i run macro it result what is in sheet1 but i want the result which is in sheet2. Problem is when current cursor position in 2 & macro run 4 and 6 are colored cell moved below cell 2 but...

Anyone help me sort this problem.