I am trying to update a macro.  I know that I can select an individual cell
using a variable by using the Cells property.  I simply insert the variable
into the parameter as an index number for a row or column.  However, if I
want to work with a range of cells, there is no way to ...

I am trying to update a macro.  I know that I can select an individual cell
using a variable by using the Cells property.  I simply insert the variable
into the parameter as an index number for a row or column.  However, if I
want to work with a range of cells, there is no way to ...

I have a table such as the one below, I would like to create a formula/macro
that will give my worksheet a comand to replace the text values on the left
with the numbers to their right. Is that possible??
ir    660

Looking for help creating an equivalent VBA public function statement for
the following VLOOKUP formula:
=VLOOKUP(L11,'Sheet'!$I$2:$K$19,2)+(L11-VLOOKUP(L11,'Sheet'!$I$2:$K$19,1))/VLOOKUP(L11,'Sheet'!$I$2:$K$19,3)*(VLOOKUP(VLOOKUP(L11,'Sheet'!$I$2:$K$19,1)+VLOOKUP(L11,'Sheet'!$I$2 ...

I've been working with a vba script that works just fine when run from
the workbook from which it will remove links to external workbooks;
however, when I set the script up in one workbook to create a new
workbook, and then I activate and call the script from there, it fails

I fetch the data from the database and bind it to a dropdown. The
dropdown value and text are different. So I've created two columns in
dropdown. The data is bound properly but I'm unable to hide the second
column i.e. value column. So how can I hide a column in dropdown?

On sheet1 in column A I have 14 tools listed in A6:A20. In column C6:C20 I
have TRUE or FALSE values which are managed by tick boxes located over column
B. Each tool has a sheet named after it. How can I make it so that if a tool
is designated a TRUE, then the sheet will show, ...

I have a workbook that imports and manipulates data from another worksheet.
I press 1 button which in turn runs about 30 subroutines and functions
totalling about 2200 lines of actual VBA Code.
Call it morbid curiosity or bragging rights... or just pure inefficiency but

Hi All.....
If someone would be so kind......I need help.  I'm trying to copy the
formatting, (including Conditional formatting), from Range A11:AG11, down the
sheet, as far as there is data in column A.....the recorder is not too good

I know I want to copy column N on a specific worksheet name where N is
variable and is a number (column 2, 5, 8, whatever).    How do I write the
code to copy that column?
Thanks,

Hi, I have never posted before but hope that someone can help me with a
problem now that I have.
I am developing a spreadsheet in which I want to give users the power to
insert additional rows, which sounds easy enough. However what I want is to

Does anyone know how to find the highest top and height property from
a collection of shapes?  Basically I am trying to find the bottom of
the lowest of a group of shapes in order to see how far downward on
the worksheet in order so that I can draw a vertical line on the same

I've built an XL application that resides on the intranet.
In this XL file, I use ADO to manipulate recordsets.
When I execute the application from my PC (XL 2002), everything works
fine.

Bob Philips gave me the solution (see hereunder) to open Excel-files in a
certain directory. Is it also possible to change the directory after
finishing this and restart the job from the beginning? In other words: is it
possible to change the line

Hello,
I have this code and it works perfectly for me (see code below). I want to
simplify it so it dosent ask me for which column to delete "0" from. This
column is always J in my worksheet. Can't figure it out though, whats the