Prev: VLookUp Error
Next: how do I turn the screen off during macro execution
From: Gord Dibben on 6 Mar 2010 16:44
Thank for the assist Roger.

I usually post the instructions but in a hurry or simply forgot.

I would guess the latter<g>


Gord

On Sat, 06 Mar 2010 09:47:19 +0000, Roger Govier
<roger(a)technology4nospamu.co.uk> wrote:

>HI
>
>you need to copy Gord's function code to a standard module, not to the
>Worksheet itself.
>
>Alt+F11 to invoke the VB Editor
>Insert>Module
>Paste code into white pane that appears
>Alt+F11 to return to Excel

From: Keyrookie on 8 Mar 2010 17:59

Gord Dibben;934452 Wrote:
> Thank for the assist Roger.
>
> I usually post the instructions but in a hurry or simply forgot.
>
> I would guess the latter<g>
>
>
> Gord
>
> On Sat, 06 Mar 2010 09:47:19 +0000, Roger Govier
> <roger(a)technology4nospamu.co.uk> wrote:
> -
> >HI
> >
> >you need to copy Gord's function code to a standard module, not to the
>
> >Worksheet itself.
> >
> >Alt+F11 to invoke the VB Editor
> >Insert>Module
> >Paste code into white pane that appears
> >Alt+F11 to return to Excel-

Thanks Gord & Roger,

I copied the function into a module and it worked fine. One last
puzzle piece...

In cell O154 I have this formula:
=NOW()
In cell Q154 this formula:
=DATE(YEAR(O154),MONTH(O154),1+7*2)-WEEKDAY(DATE(YEAR(O154),MONTH(O154),8-1))

This gives me the 2nd Sunday of every month. I'm wanting this cell,
Q154, to show the extensions. How do I combine the formula I'm already
using and the new one that will reflect the extensions? For this month
cell Q154 would show 14th. For next month it would show 11th.

Thanks again,

K




--
Keyrookie
First  |  Prev  | 
Pages: 1 2
Prev: VLookUp Error
Next: how do I turn the screen off during macro execution