122 reputation
3
bio website
location
age
visits member for 2 years, 3 months
seen Aug 2 at 16:48

Nov
2
comment How to make Excel formula work in all regions
Thanks! It works here too. There must be some other reason a client is reporting errors. Maybe it has VBA that is applying formula. If you add that as an answer I'll accept.
Feb
28
comment How to get relative worksheet references when copying formulas in Excel?
I would say that it's bad design to have Years/Months on separate sheets. An easier way would be to have a single sheet that stores data in a database format and another sheet that allows you to pick a month and year and the data is brought into that sheet.
Nov
25
comment Registering OCX on 64-bit Windows 7
Why do you want MSCOMM32.OCX? If it's for a calendar date picker there are better methods.
Oct
2
comment Hiding worksheets & protecting cells in Excel 2010
@ScottHoltzman - It's possible to hide the sheet tabs. In File/Options/Advanced/Display options for this Workbook/Uncheck Show Sheet Tabs
Sep
14
comment Best wifi frequency for penetrating woods
@Keltari - Can you provide any evidence. I agree with CodyC that lower frequencies penetrate better en.wikipedia.org/wiki/IEEE_802.11 & en.wikipedia.org/wiki/Line-of-sight_propagation
Sep
11
comment Identify date/time format
I've just calulated it - it's ms for the values I posted. I think Unix Epoch time is defined as seconds but the values I have are to ms accuracy. So you're all right!
Sep
4
comment How to get colour variations
Excellent - thank you. I've managed to find this site hslpicker.com/#FF8683, based on suggested keywords, which has exactly what I need.