Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New macro user query
I am new at doing custom macros and would like to know if someone can help
with the following issue I have. I would like to create a macro which goes to column A of that current row, makes the data in that cell strikethrough, then goes to column D and inserts the current date. Is this possible? Thanks in advance for any help Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New macro user query
go to File=Open and click the tools dropdown. Select Find and see if there
are any conditions there that would cause you not to find your file. -- Regards, Tom Ogilvy "Ja" <jason wrote in message ... I am new at doing custom macros and would like to know if someone can help with the following issue I have. I would like to create a macro which goes to column A of that current row, makes the data in that cell strikethrough, then goes to column D and inserts the current date. Is this possible? Thanks in advance for any help Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New macro user query
Try this jason
Sub test() Cells(ActiveCell.Row, "D").Value = Format(Now, "yy-mm-dd") Cells(ActiveCell.Row, "A").Font.Strikethrough = True End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Ja" <jason wrote in message ... I am new at doing custom macros and would like to know if someone can help with the following issue I have. I would like to create a macro which goes to column A of that current row, makes the data in that cell strikethrough, then goes to column D and inserts the current date. Is this possible? Thanks in advance for any help Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
another macro query - deleting a worksheet within a query | Excel Discussion (Misc queries) | |||
how to do a web query on an web browser on an user form using macros | Links and Linking in Excel | |||
Another User Form Query | New Users to Excel | |||
How do I know if another user have inserted a web query on my wshe | Excel Worksheet Functions |