Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
[Excel 2002 says] Jello again!
(please be patient, there is a question below...) I'm working on a spreadsheet that's formatted to look like a calendar. There's a month-name across the top of the sheet (spanning multiple cells); Weekday names under that, and "days" arranged just like squares you see on a calendar. Days are always a fixed width (two cells) but each day can hold a different "list" - the number of rows in each day WILL vary (OK, the days are really rectangles). It's expected the list in each day will contain 4 to 10 rows. When the user changes the sheet, it initiaites a lot of input validation and processing which are very dependent on the date, and row/col within the date being edited. It seems impractably messy to figure out the date/row/col from absolute coordinates given that, calendar top/left is variable, rows/cols between cells is variable, day height (row-count) is variable, (as user adds rows, can grow, pushing down remaining weeks.) I'm not saying it's impossible, just impractical. If not, I could write date/row/col data on a "shadow" sheet. It would be great if a date/row/col typedef could be cast to/from a string stored in shadow-sheet: Q. Is there a way, with VBA, to cast arbitrary data-structures to/from strings? Correlary question: Can cells reliably store "binary" strings? Any help, ideas, constructive criticism is appreciated, Cheers! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
Userform problem with "obj doesn't support this property or method"error message. | Excel Programming | |||
combining or "flattening" rows | Excel Worksheet Functions | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) |