AND VBA MACROS
Sent: Mon, January 10, 2011 6:00:51 PM
Subject: Re: $$Excel-Macros$$ Understand macro code in timesheet
Hi Paul
Thanks for the reply
I followed your instructions.
When I right click 'Next fortnight' button and select 'Assign macro' -
It
goes to second line o
Hi Paul
Thanks for the reply
I followed your instructions.
When I right click 'Next fortnight' button and select 'Assign macro' -
It
goes to second line of the code - "=ECHO(FALSE)" in 'Macro1' Sheet
When I right click Re-Calculate' button and select 'Assign macro' - It
goes
to second line of the
MS EXCEL AND VBA MACROS
Sent: Sun, January 9, 2011 8:04:58 PM
Subject: Re: $$Excel-Macros$$ Understand macro code in timesheet
Dear Paul
Thanks for the reply.
The sheet has been used in the organisation for long time and there is
no current owner of it.
Currently the workbook is Excel 2007 ve
> sorry,
>
> Paul
>
> ____________
> From: anil
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, January 5, 2011 6:11:57 PM
> Subject: $$Excel-Macros$$ Understand macro code in timesheet
>
> Problem - I have one spreadsheet which is used to reco
ersion of Excel you're using
and perhaps we can find someone with expertise with it.
sorry,
Paul
From: anil
To: MS EXCEL AND VBA MACROS
Sent: Wed, January 5, 2011 6:11:57 PM
Subject: $$Excel-Macros$$ Understand macro code in timesheet
Problem - I have
Problem - I have one spreadsheet which is used to record our time
sheet in office. Sheet 1 is named Macro1 and has following code/lines
in the cells starting from A1 till A18:
Next Fortnight
=ECHO(FALSE)
=SELECT("R56C13")
=COPY()
=SELECT("R9C15")
=PASTE.SPECIAL(3,1,FALSE,FALSE)
=SELECT("R10C4:R49C5
