Re: $$Excel-Macros$$ autofill vba

2010-03-19 Thread OSAVentures Calamba
Thank you very much. I appreciate. On Fri, Mar 19, 2010 at 9:13 PM, rf1234 rf1234 wrote: > Hello Dear > Attached is the sample sheet, Perhaps it can help you to print & achieve > suitable result. > > > > > > > > > > > > > > > > > > > > > Hope It Will Help > Happy To Help > :) > Shyam > > > On Fr

Re: $$Excel-Macros$$ autofill vba

2010-03-19 Thread rf1234 rf1234
Hello Dear Attached is the sample sheet, Perhaps it can help you to print & achieve suitable result. Hope It Will Help Happy To Help :) Shyam On Fri, Mar 19, 2010 at 12:52 PM, OSAVentures Calamba wrote: > Hi All, I'm trying to fill C6 with value of 1 then selecting that and >

$$Excel-Macros$$ autofill vba

2010-03-19 Thread OSAVentures Calamba
Hi All, I'm trying to fill C6 with value of 1 then selecting that and filling the cell below it with series until the last row of B, my code is not working. whats wrong? thanks Sub Fillnumber() ActiveSheet.Unprotect curr_row = Range("C6").Row curr_col = Range("C6").Column last_row