Re: plus 1

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

On Jul 13, 3:20 pm, "Rick Rothstein \(MVP - VB\)"
<rickNOSPAMn...@xxxxxxxxxxxxxxxxx> wrote:
Try it this way....

If ActiveCell.Column = 2 Then ActiveCell.Value = ActiveCell.Value + 1

Rick

"alex" <sql_...@xxxxxxxxx> wrote in message

news:1184349843.945383.92430@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Jul 13, 1:54 pm, Tom Ogilvy <TomOgi...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
ActiveCell.Value = ActiveCell.Value + 1

--
Regards,
Tom Ogilvy

"alex" wrote:
Hello Experts,

I have an xls work*** in which users paste a date from another
application.
Once pasted, I want to increase the value by one day (in the same
field).
Is that possible? And if so, how?

alex- Hide quoted text -

- Show quoted text -

thanks Tom for your response.
I want to limit this function to only column B. How would I set that
up, and what Sub would I use?- Hide quoted text -

- Show quoted text -

Thanks Rick for your help.
I also need to know what Sub you'd use, and if any arguments are
required...unless I'm misunderstanding where to place the code.

alex

.

Quantcast