AHHHHHH! Excel VBA Help!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris (Chris_at_discussions.microsoft.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 14:25:02 -0700

Ok, going nuts. How do you say "go to the next cell down" in VBA? ex:
I'm pasting something into cell A23 and would normally hit enter to go to
cell A24. TIA

-Chris

Relevant Pages

  • Re: Preventing pasting except for Paste Values
    ... I just want to restrict pasting to pasting only values. ... to prevent users from overwriting the cell formats (including conditional ... formatting) and validation rules I have established. ...
    (microsoft.public.excel.programming)
  • Re: Pasting a file into Word 2003
    ... Is it possible that it *is* pasting it but that the view is somehow constrained - perhaps by a fixed size table cell, ... > Robert M. Franz wrote: ... >> Hi Lou ...
    (microsoft.public.word.docmanagement)
  • Re: Cannot paste a block of formulas from one sheet to another
    ... One workbook was using a base year of 1900 and the other was using 1904. ... One way to add those four years back is to find an empty cell, ... It works now, pasting formulas, but dates are the only ... spreadsheet to another ...
    (microsoft.public.excel)
  • Re: Cannot paste a block of formulas from one sheet to another
    ... One workbook was using a base year of 1900 and the other was using 1904. ... One way to add those four years back is to find an empty cell, ... It works now, pasting formulas, but dates are the only ... Today it is pasting the values from the original spreadsheet instead ...
    (microsoft.public.excel)
  • Re: Pasting only the formulas and not the data
    ... <<"one of the first things that came to my mind were pasting a formula as ... from the formula bar, then, then pasting in any cell or any number ... And to see the formula of another cell there is my GetFormula ... David McRitchie, Microsoft MVP - Excel ...
    (microsoft.public.excel.newusers)