Filling in blank cells

**kevinjay1** · 12-17-2012, 02:23 PM

Good afternoon, I have a spreadsheet with about 10 years of data. The data dates are in column A, but are not filled in all the way - if 3 samples were collected on 1/2/06, only the first sample has a date. I would like to autofill the blanks with the previous number. I have a macro that I am trying to put together, but seem to have something wrong, could anyone please correct it for me? I don't mind using one for each sheet, I can run it for each sheet individually.

Please Login or Register  to view this content.

Thanks!

**dilipandey** · 12-17-2012, 02:43 PM

Hi kevinjay1

Suggest you to put your code in CODE TAGs.. see the rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

**kevinjay1** · 12-17-2012, 02:50 PM

Made the change, are there any suggestions though?

**6StringJazzer** · 12-17-2012, 03:16 PM

Your code worked beautifully for me. Can you explain what "something wrong" means?

**kevinjay1** · 12-17-2012, 03:39 PM

When I plugged it in, perhaps I put it in wrong, here is what I did

The way that I did it is probably the problem. I opened up Visual Basic in the Developer tab (2010), double clicked on the sheet that I was going to use it in and pasted the code into that sheet. I then click on the Macro button and get a "Compile error: Sub or function not defined".

As I said, my application of the application was probably flawed. Am I correct in thinking that I am incorrect?