Programming

Formatting previous selection
After selecting a cell (or range) i wish to be able to 'click' on another cell , say A1, and the formatting of the previously selected range to be changed, such as the interior color. The idea is to speed up / automate the formating of the selected range. Any ideas? ... 31 May 2010 10:52

Problem with - sign in sheet name??
I have code that will get a range method failed error when trying to execute the statement: x=range(s & i) where s="Brazil-008.ord" and i is any value. The Brazil-008.ord tab (worksheet) does exist. If I change the salur os s and the name of the worksheet so that it does not contain the minus sign it works gre... 31 May 2010 06:31

Replacing spaces with underscore for specific expressions
Dear Experts: I got numbers in column C with the following Synthax (xxxxSpacexxx), e.g. 0250 434 or 0748 314 All these expressions are located in Column C and the 'Space' should be replaced with an 'Underscore'. After the replacement the expressions should look like this: 0250_434 or 0748_314 Please no... 2 Jun 2010 02:16

Change Times
Hi all How could I change 1m 1.40s it's formatted as General, to read as time 61.40 Thanks Dave ... 4 Jun 2010 15:54

Coloring Alternate lines
I want to color columns A to E on every other line. I can't find an ISEVEN or ISINTEGER function, so how do I do That in VB? Thanks, Jim Berglund ... 31 May 2010 10:52

How to Show/Hide Columns or Rows with no data via VB
Hi, I am need of some advice please. I have a spreedsheet (2007) which I designed as an attendence register. Currently it works well but I want to improve on a few matters. For the main page I have a column with the date, next column day, then the next 40 columns are set for the crew employees. These are b... 31 May 2010 02:15

Change Color for Drawing Line Object
Below is code for a line drawing, but it defaults to Blue. I would like to change the color to red. ------------------------------------------------ Sub mineLeft() Dim nStart1 As Double, nStart2 As Double Dim nEnd1 As Double, nEnd2 As Double Dim rng1 As Range Dim rng2 As Range Set rng1 = ActiveCell.Offset(0... 31 May 2010 06:31

Day of Week from dd/mm/yyyy
How do you find the Day of Week from a given date, "dd/mm/yyyy". I know it is given by "dddd" but I need the reverse process. I would be open to the numbers of the Day of Week too. I am given the: mm=11 dd=15 yyyy=2009 find dddd or number of the Day of Week ... 30 May 2010 20:53

delete file in addin directory
I wan't to retrieve the addin directory of a user in a network environment search if a specific file exists and Delete that specific file in that directory. What is the code for that? ... 30 May 2010 11:06

Running macros when multiple Excels are open
Some of the macros I have written sometimes do not function correctly if another instance of Excel is open. The other instance usually also contains macros that may or may not have been executed. I thought I read somewhere that this is a common problem but a recent search has not turned up anything. Does anyone k... 30 May 2010 12:11