Could anyone tell me how I can select columns A, B, C, and F of th
active cell's row?
Thanks
--

I am getting a message saying 'autofill method of range class failed
when I run my macros. Is there any way to remedy this? I have abou
9000 rows of data.
Cheers

My macros run very, very slowly. This is not a performance problem wit
my excel as I have other programmes with macros that run excellently
Is there a way of speeding them up
--

Please could somebody help me.
I have got so far and come to the end of my knowledge base, I need t
get further.
Here is my problem:

I have number of days, and i will like thet Excel callculate for me how meny
is that in years, months and days.
1344 working days, how meny is thet in years, month and days?
Please help.

Hi! I was wondering if it is possible to write a macro so that if any of the
words "admin", "manager" or "co-ordinator" are entered into any of the cells
A1:B3, then a message box will pop up saying "Your current user status allows
editing". It would be great if it would work if ...

I have 5mio currency values in an unsorted VBA array. I need to find the
99.99th percentile highest value without writing the array to a spreadsheet
and using the worksheetfuntion.percentile
Any ideas?  TIA!!

I have a range of cells A1:A10 in which data is pasted from AS400.  Th
data is pasted in a 2340- format for a negative number.  What I'
looking for is when the data is pasted into these cells, for excel t
automatically change the format from 2340- to <2340>.

i I need to concatenate several cells to make up one cell as a description
for a item number. e.g.
cell a1 may contain the item number and cells b1 and b2 the part description
that have to be concatenated to cell c1 to make the full description. The

hi
I have a commandbutton placed on a sheet call "Information" the
Commandbuttons Name is Updater.
i have the following piece of code

I am new to Macros and I have failed to write one to compare 2 cells
and highlight the difference between the strings in those cells.  The
one tried highlighted the whole cell instead.
Compare string in column B to Column A and return the different

(this is a repost, the first time I sent it in…it didn’t post??)
I have a question about an earlier post in the worksheet functions group
from 12/09/04. There was a question about converting numbers  to time without
putting in the colons. The answer was a referral to Chip ...

How can one create a macro that open another workbook that detects if
the workbook is allready open? Example: If I run my macro to activate
the window,but the book is not open, it shows an error. The same if I
run my macro to open the workbook, but it is allready open it shows

How do i check if a cell has #REF! anywhere in the cells formula?
ie check if Range("A1").formula =#REF! Or ='Sheet1'#REF! or any formula with
#REF! in it.
Thanks

I was playing around with the Visual Basic editor window and have now ended
up with the Project Explorer; Properties; and code panes not grouped
together. When I rightclick and choose dockable, the window docks to the top
of the window but not to the other panes.