Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Left justified date/time in new cell ?
This is my attempt to place the current date and time left justified
into a new cell. The xlLeft keeps giving me an RUN TIME ERROR error, even though I see it being used in the newsgroup examples..... ActiveSheet.Rows(1).Insert ActiveSheet.HorizontalAlignment = xlLeft ActiveSheet.Cells(1, 7) = Now() Can anyone point me in the right direction? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Left justified date/time in new cell ?
You need to speifiy what you want to apply the Left Alignment to. Try this:
ActiveSheet.Rows(1).Insert ActiveSheet.Cells(1, 7).HorizontalAlignment = xlLeft ActiveSheet.Cells(1, 7) = Now() HTH, Elkar "Samuel" wrote: This is my attempt to place the current date and time left justified into a new cell. The xlLeft keeps giving me an RUN TIME ERROR error, even though I see it being used in the newsgroup examples..... ActiveSheet.Rows(1).Insert ActiveSheet.HorizontalAlignment = xlLeft ActiveSheet.Cells(1, 7) = Now() Can anyone point me in the right direction? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Left justified date/time in new cell ?
On Apr 27, 2:34 pm, Elkar wrote:
You need to speifiy what you want to apply the Left Alignment to. Try this: ActiveSheet.Rows(1).Insert ActiveSheet.Cells(1, 7).HorizontalAlignment = xlLeft ActiveSheet.Cells(1, 7) = Now() HTH, Elkar "Samuel" wrote: This is my attempt to place the current date and time left justified into a new cell. The xlLeft keeps giving me an RUN TIME ERROR error, even though I see it being used in the newsgroup examples..... ActiveSheet.Rows(1).Insert ActiveSheet.HorizontalAlignment = xlLeft ActiveSheet.Cells(1, 7) = Now() Can anyone point me in the right direction? Thanks!- Hide quoted text - - Show quoted text - That did the trick. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can text be full-justified within a cell? | Excel Discussion (Misc queries) | |||
rows top-justified & bottom-justified in same sheet looks bad | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
how to make number as text and left justified? | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |