In a macro I have
;;;  Lines
;;;   not shown..
Range("A5").Select

Gang -
In set range r this code works:
With r
  .formula = .value

I would like to sort a combox List by ascending order.
Currently, my macro does the following fine, need
additional code to sort the data, many thks
Private Sub ComboBox1_DropButtonClick()

I have several user form.  With one, when it appears on the screen, you can
select and move it around and have many, many images of it on the screen.  I
use the following for all forms:
application.screenupdating = true

I'm looking to create a macro which will run from a Form Button. Form
buttons will be located at the end of each row. How can I make the form
button select the cells in the row that the form button is on? For example
if the active cell is c12 and I press the form button at the ...

Please help me to make my Do Until Loop work with multiple conditions.
The outcome is correct using just one condtion (either works), but when
I try to use both, the loop goes one too many iterations.
Public Function SetNextDate()

Hello.  I'm quite new to excel VBA and could really use help with a
function.  Here's the situation.
When judging dance competitions, there are up to 5 judges.  Their scores are
listed in adjacent columns.  I need to call a function in the next column

I've seen the custom chart type offering 2 x axes in a single chart.  I
wonder if it's possible to program in more than 2?  I actually need 3,
believe it or not.  I could just use the 3-d view and rotate it to 0
degrees aspect, but that chart object doesn't seem to stretch sideways

How can I copy column A and column D from all sheets to a new sheet
while offsetting the paste ie the 2  column being pasted next to the
other
thxs

Hi, wondering if anyone can help me. I have an Excel spreadsheet i
which I have a macro which filters the data several times, each tim
copying the data to a new Excel sheet and saving them. However, ther
are 17 of them and I then have to go through each individually and zi

I have some code from Ron's site that WAS working, but now is NOT attaching
a file to the email when I added some code. I am creating the zip file, but
also another file with an "E" attached that I want to use as the attachment
instead of the zip file.

At present I have three excel files, say 1, 2 &3 each with a tab relating to
a cost centre, say A, B & C as follows:
1
A B C

Hi,
I've created a simple funcion to calculate the volume based on three inputs,
height, width and depth. I've make the variables bytes. When the result of
the volume is over 255 I get an overflow error. See the function below:

How can I copy column B and column E from all sheets to a new sheet
while offsetting the paste ie the 2  column being pasted next to the
other
thxs

I need what I think would be a simple macro to an advanced user.  It needs to
start when the book is opened and update all external links (paste specials)
every 20 secconds.  I have no idea what commands are needed to do this and
have no idea where to look for information to make ...