autofill column

[mubashar]

i want VBA code for column C to be auto filled cells with the word "Absent" if any cell is left blank.

[gsnidow]

mubashar, you could try something like this. You will need to determine how to limit the range of column C. This code assumes the whole column up to the last used cell in C is fair game.

Greg

Please Login or Register  to view this content.

[mubashar]

it doesnot work

[FDibbins]

You dont need VBA for this. You could use a simple =IF(A2="","Absent","") in C2, copied down. Adjust references to suite

[mubashar]

i want , eg if cell c1 has value "OK" , i hit enter key, it goes to cell c2, does not write anything and hit enter key , selection goes to c3 cell leaving empty c2 cell. i want when i left any cell in column c blank , the work "Absent" automatically be written in it.

[FDibbins]

OK thats different to your 1st request. You will need VBA for this

Although another option mighht be to have "absent" in all cells, and then when you go to that cell, whatever you enter will replace that

[hafizimran]

The following code given by gsnidow works perfectly, what's problem? you should upload your worksheet for quick ref.

mubashar, you could try something like this. You will need to determine how to limit the range of column C. This code assumes the whole column up to the last used cell in C is fair game.

Greg

Please Login or Register  to view this content.

[gsnidow]

mubashar, I think this is more in line with what you want. Keep in mind, you have not given an input as to the limits of the range in column C, so, once again, I'm guessing. If it "does not work" again, then I would suggest you upload a sample workbook with data and comments, so we know *exactly* what you are needing to do.

Greg

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[mubashar]

thanks gsnidow and all others that help me. it is working nice