S
Shiraz Mistry
Hi all,
I want to position my cursor in a cell (in Column A) and press a macro
button to fill in the rest of the week.
For example, cell A91 should fill the rest of the week as the above week,
that is, A81:H89.
Currently, this is the code for the table-
Sub Table()
'
' Table Macro
' Macro recorded 6/24/03 by Shiraz Mistry
'
'
Range("A71:H79").Select
Selection.Copy
Range("A81").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
I know it has something to do with the above range:
Range("A81").Select
but I am not sure what and how to change this line.
I can send the workbook to people that may be interested.
Any help would be appreciated,
Thanks,
Shiraz J. Mistry
I want to position my cursor in a cell (in Column A) and press a macro
button to fill in the rest of the week.
For example, cell A91 should fill the rest of the week as the above week,
that is, A81:H89.
Currently, this is the code for the table-
Sub Table()
'
' Table Macro
' Macro recorded 6/24/03 by Shiraz Mistry
'
'
Range("A71:H79").Select
Selection.Copy
Range("A81").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
I know it has something to do with the above range:
Range("A81").Select
but I am not sure what and how to change this line.
I can send the workbook to people that may be interested.
Any help would be appreciated,
Thanks,
Shiraz J. Mistry