Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto insert
Hiya again!
i have this so far Sub Clear_details() Worksheets("Details").Range("E10").ClearContents End Sub Which clears a cell. I also need this function fo insert into a cell E13 "Please select" thx --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080107-0, 07/01/2008 Tested on: 08/01/2008 10:07:53 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto insert
Try this
Sub Clear_details() With Worksheets("Details") .Range("E10").ClearContents .Range("E13").Value = "Please Select" End With End Sub Mike "Steve" wrote: Hiya again! i have this so far Sub Clear_details() Worksheets("Details").Range("E10").ClearContents End Sub Which clears a cell. I also need this function fo insert into a cell E13 "Please select" thx --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080107-0, 07/01/2008 Tested on: 08/01/2008 10:07:53 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto insert
?B?TWlrZSBI?= wrote in
: With Worksheets("Details") .Range("E10").ClearContents .Range("E13").Value = "Please Select" End With Super. thanks Mike --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080107-0, 07/01/2008 Tested on: 08/01/2008 11:02:43 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need VBA script to auto-insert value upon row insert | Excel Worksheet Functions | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Auto Insert/Auto Formula? | Excel Worksheet Functions | |||
auto row insert | Excel Worksheet Functions | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |