Programming

Mobile Office 6.1, Excel Mobile
I was wondering if anyone could help me figure out why when I open up a spreadsheet in mobile excel it doesn't recognize the drop-down list that was formated in Excel 2003. Any help would be greatly appreciated, Thanks, Chance ... 16 Jul 2008 16:09

Hide a Cell Value
Hey All, I have a worksheet where I need to hide the contents of a cell (we'll say A2)....such as making it all asterisks (*) just like a password field. But, when another cell's (we'll say B1) value changes, A2 needs to reveal it's true data.....and then when B1 is blank again, A2 needs to revert to asteris... 18 Jul 2008 06:11

Insert line in first row of CSV text file with VBA
I have a CSV text file and would like to insert a row at the top using the VBA Write statement from Excel. I am able to append, but can not add to the first line. ... 16 Jul 2008 17:11

How to select a range based on what's in the row header?
I would like my macro to look for the word "Date" and then create a range called "Date_Column", rather than hard-coding it that Date will always be column B, column D, etc. Any suggestions or pointers to tutorials? Thanks, Rachel ... 16 Jul 2008 16:09

Macro Need
A good day ! Please very much to provide me this kind of macro which provide me the next type of combination ( I don't know if what I need so strong is a combination or a permutation) : here is an simplified example : 1|1|1|1|0|0|0 1|1|1|0|1|0|0 1|1|1|0|0|1|0 1|1|1|0|0|0|1 1|1|0|1|1|0|0 1|1|0|1|0|1|0... 18 Jul 2008 17:33

Sheet Tabs
I have a workbook with eight visible sheets. The horizontal scroll has been resized to allow all tabs to be visible - however when code is run on sheet 8 "Search Rounds" the first three sheet tabs disappear to the left. They can be easily made visible by clicking on the 'Navigation' buttons - so it is just a m... 16 Jul 2008 16:09

Filldown Formula
I'm looking for a foolproof technique to Filldown a formula when I don't know in advance how many rows i might have to fill. However, the column Immediately to the left will be populated when the formula is applied. Any suggestions would be great. Thanks, K ... 16 Jul 2008 16:09

Chart Property (e.g.: .HasTitle) reset fails with run-time err
Sir, Thanks for the information. I was unaware that one had to put data into a chart before being able to add a title to it. I have tried it and it works, but I don't like it. This is a hidden "feature" (so typical of our friends at MS), because it is nowhere stated in the documentation. It also violates... 16 Jul 2008 17:11

Keep string without rightmost letters
I have a huge list of products that have different model types denoted by letters at the end of the product i.e. ProductA 5760tr ProductA 5760xsn etc. I eventually want to do a vlookup but only have "ProductA 5760" in my data to be pulled from. Can I get rid of all the letters after the numbers even if th... 16 Jul 2008 16:09

border for if
Hi all. On one of my macros, I want to set it up to run through a single sheet until it finds the last row of contents. However, I want it to only do select cells, that are bounded by borders. I.e., instead of my having to activate for each cell group, I'd like to I thought something like this would do it, but... 17 Jul 2008 11:40