Re: cell formatting won't update

Well, here's hoping that sacrificial cell wasn't used in any subsequent
formulas/code <gd&r>.



Max wrote:

"Dave Peterson" wrote:
I sometimes just go outside the used range (ctrl-end, then down one
row--especially in code).
But mostly, I'm careful to select an empty cell <vbg>.

.. think I'll stick with the single stroke of the Delete key <vbg>
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson
.

Relevant Pages

  • Re: SUMPRODUCT
    ... =sumproduct() likes numbers: ... But be careful. ... An empty cell will look like it has a monthof january. ... Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: cell formatting wont update
    ... I'm careful to select an empty cell. ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need some help with excel spreadsheet...
    ... > The second thing is the subtotals. ... > After I got this on the first working for the first row I did a special ... >> Select an empty cell ... Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: Date format issue
    ... Excel could be converting values to dates for things that are ... You'll want to be careful when you choose the order of the date. ... > But, if you give XL the wrong info on the existing format, nothing happens, ... > Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: Turn off text to columns
    ... "Dave Peterson" wrote: ... Find an empty cell ... I used text to columns in Excel delimited with hypens. ...
    (microsoft.public.excel.misc)