Re: $$Excel-Macros$$ How to fix a vba code that returns a cell reference

2014-09-22 Thread Mr_Bill
""", D" & NextRw & > ", """")" > > > --- > Now, on to my second question: WHY? > Do you want the cell (cells(i,2)) to contain

Re: $$Excel-Macros$$ How to fix a vba code that returns a cell reference

2014-09-22 Thread Paul Schreiner
uot;")" --- Now, on to my second question: WHY? Do you want the cell (cells(i,2)) to contain the value or do you really want it to contain the formula? why not make VBA do the work? Why not use somethi

$$Excel-Macros$$ How to fix a vba code that returns a cell reference

2014-09-21 Thread Mr_Bill
How this works is if data is input in the next available cell in a column this code sees what cell it was and in another of area of the sheet input the cell location like =YXX the XX being the cell number. and Y being the Column using the nextrw from this line NextRw = ws.Range("A190").End(