Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar manipulation
I have a calendar on an Excel 2003 sheet.
1) Column "A" is invisible for historical or hysterical reasons I can't remember. The sheet is not frozen. Selecting column "B" and the list of row numbers and doing Format/Columns/Unhide does nothing. In the Immediate pane of the Code window, commands such as columns(1).hidden=false also do nothing. This is unimportant, but I report it. 2) Each month has 2 columns, the first is headed by a month name followed by day numbers, the second is free format to hold data. Currently columns("C:GJ") are hidden. I think I need a macro to unhide 2 columns next to the unhidden columns. e.g. columns("GI:GJ").hidden=false. I am looking for an economical way to encode this. My current thinking is a loop to search for a hidden = false cell and make 2 previous cells hidden=true. 3) I also show this file on my Android mobile phone or cellphone. cells("GK",1) is =DATE(2015,8,1) with format = "mmm"). On the phone, this appears as 2103 and sometime later is converted to "Aug". The app is "Sheets". Can anyone suggest a more efficient way to generate "Aug". -- Walter Briscoe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
Modify Yearly Calendar to Monthly Calendar Excel 2000? | Excel Programming | |||
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation | Excel Programming | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |