I use a macro to select a cell.  How can I make sure this cell is
positioned as the first cell outside of the frozen panes?
Matt

When I open  microsoft.public.excel.programming page, then on the
left
hand side following  Ads appearing, it should be in the Right hand
side, but it is appearing on left hand side, so I can not read any

Help
Archery club memnbers scores
Thanks

Am trying to write a vba program which needs to redim an array and
populate it with new numbers. But when i get to the part of the code
with for loop statement with the redim array inside the debugger just
jumps over that part of the code and go to another section.

Hi (Question from a newbie Maroc user),
I'm trying to record a macro which builds a pivot table and also creates a
chart though it keeps failing when I run it.  Can anyone point me to general
info on macros and pivot tables or offer suggestions on common issues I

I have a userform with a textbox on it.
On loading it picks up a number from a cell on the spreadsheet. I want
a % sign in the textbox with the number, ie 15%. I use the following
code to achieve that.

I have some mathematic formulas that I am working with, and I need to see
what formulas generate prime numbers.  Please let me tell me if you know a
way of getting Excel to identify which numbers are prime.
Thanks,

I would like to have a column in a list box that contains numbers with
decimals and have the decimals aligned.  Another column has text that
should be left aligned.  Is there ANY way to do this.
A similar question: Can I apply the format of the cells in the worksheet to

I have copied this from a form I created earlier only I cant remember what
each item refers to as I cleavely named them all the same thing!!
Could someone look at this and let me know what they should be refering to
then I should be able to modify the code for my new form.

Excel 2003
I have dates in Cells B4 (10 March 2007) and F4 (20 October 2007).
Formatting is "dd mmmm yyyy".
I have,  as part of a macro:-

I have a column of data which needs to be checked for duplicates, how
would I do this with a macro?  The data is a list of names which have
been assigned to tasks.  I can't have the same person assigned to two
tasks/jobs.  Would be great if the duplicates are shown in a different

1.Have to compare contents of 2 cells.

I think I've finally found the right group!
I have an old XLL that I call in Excel VBA using Application.Run. I am
trying to move this code to Access. In this case Application.Run does
not work. O could late-bind to Excel and use myXL.Run, but the

I need to insert a line at the bottom page using macro programming.

macro below works perfectly fine as it get percentages of Sheet1
column E amounts and other data in same row to Sheet2
Sub test()
Dim LastRowColD As Long