Show a range in a shape/picture object 4 140 (11/20/2009 3:44:07 PM)
I know I have done this before, but I cant remember how I got there... I have a range of cells that need to be shown below another range of cells. The Range of cells that will be shown in the shape/pic h...
Utf

Feasibility of 365 day workbook??? 4 184 (11/20/2009 10:22:48 AM)
I'm thinking about creating a SINGLE accummulative worksheet for the year 2010 to save our company transactions. Each day, we will fill in 260 cells of data, which means that after 365 days (1 year), our s...
Robert

referencing web site object 3 195 (11/18/2009 4:40:03 PM)
Hi have been using a dump routine posted by Joel to ascertain the reference for objects in several web pages including three for mileage calculation. Am unable to return the mileage by road output from the f...
Utf

Updating links to external files using macros 3 434 (11/19/2009 11:57:01 AM)
Hi all I have a file which contains links to data in an external file. Every week I need to update the link to a new file that is created. So for example, at the moment the link goes to a file called "Sa...
Utf

sort dynamic range on active cell 3 339 (11/18/2009 2:37:01 PM)
Hi there is there anyway to sort a dynamic range (ie amount of columns and rows may vary) based on the column of the active cell. to make things even more complicated i would like to have a button that w...
Utf

userform list setup 1 192 (11/20/2009 3:12:01 PM)
I need to make an userform with a field that will include a list of items... how do I do it...? will listbox work for it? how do I initiate the listbox so while runing the macro it will show the options ...
Utf

Excel 2007 Smart Forms 0 300 (11/20/2009 4:17:01 PM)
Is there a web site that I can go to get find Excel 2007 Smart forms for free? I am trying to create a user form that will not let a user go on to the next question or worksheet without filling out all req...
Utf

conditional format -- if not a date, then highlight cell 1 314 (11/20/2009 3:40:01 PM)
How do I enter a conditional format to highlight the cell if it's not a valid date? I tried "formula is": =if(not isdate(C10)) <>if(isdate(C10)) Your help would be greatly appreciated!! ...
Utf

Update value. Function 2 143 (11/20/2009 1:26:43 PM)
Hello, I created a simple function on VBA as follows: Function Test() As Integer Dim I As Single For I = 17 To 24 Test = (Test + 1) * Range("Examples_1_a_4!B" & I) Next I End Function On...
shapper

Remove a shortcut from desktop using VBA code 1 857 (11/20/2009 2:44:01 PM)
I have a program that uses VBA code to creates a shortcut on the desktop. I want another program to remove that shortcut. Can someone show me how to remove a shortcut using VBA code. Thank you very much....
Utf