MACROS excel-macros@googlegroups.com
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
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 version. It is simply a
spreadsheet with xlsm
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
@googlegroups.com
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 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
with expertise with it.
sorry,
Paul
From: anil dhi...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
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
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)