Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

; > ** ** > > On Fri, Mar 23, 2012 at 6:34 PM, dguillett1 wrote:* > *** > > http://contextures.com/xlDataEntry02.html#Fill > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > > > *From:* Jim Sch

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

http://contextures.com/xlDataEntry02.html#Fill Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Jim Schug Sent: Thursday, March 22, 2012 8:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Simple VBA to Fill in blanks Hi, I'm nearly brain

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

you can also assign the macro task 1 select column a 2 press f5 3 press special 4 select blank 5 ok 6 edit menue 7 press delete 8 shift cells up ok On Fri, Mar 23, 2012 at 7:04 AM, Jim Schug wrote: > Hi, > I'm nearly brain dead (tired) and can't think straight. I have a simple > issue. A macro

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

Dear Jim, Please try it.. Sub Fill_Blanks() Cells.SpecialCells(xlBlanks).Delete End Sub -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Fri, Mar 23, 2012 at 7:04 AM, Jim Schug wrote: > Hi, > I

$$Excel-Macros$$ Simple VBA to Fill in blanks

Hi, I'm nearly brain dead (tired) and can't think straight. I have a simple issue. A macro to fill in blank values if found with the value from the cell above. For example 101 1015 Would fill the blank rows with 101 until the next number 1015 is found, then it would use 1015 until an