Show a range in a shape/picture object4140 (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???4184 (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 object3195 (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 macros3434 (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 cell3339 (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 setup1192 (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 Forms0300 (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
Update value. Function2143 (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)
Remove a shortcut from desktop using VBA code1857 (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