Someone has designed a macro for me which should perform a linea
extrapolation on gaps in my dataset.
However, it appears to work across the rows as opposed to down th
columns. I require it to work on columns F-I and R-U (inclusive) a

Hi, not sure if this is possible, but if it is then you are a
genuis!!!!!!
We've got this system at work where we have to log in, though there is
a maximum of 40 users, so no more people can get in. However, if you

I have a macro that needs to tab over and enter information 4 different times
per row of information.  This happens after it finds the first blank cell in
a column.  Because the number of records change I can not tell it to select
cel "b4" then enter the information select "d4" ...

I have the below code on an MS Access Form Command Button that save
Access Queries to and Excel File. Each Query Name becomes a separat
Sheet in Excel. My problem is the Excel File opens and the Sheet is no
maximized. I would like for the Excel Sheet to be maximized when th

I am looking to do a search and replace for some code in all the codeModules
in my VBA Macro program.  I am trying to do an automated program that
searches for and finds the Excel Workbooks, finds what modules are each
Workbook, and then replaces code.  So it would replace ...

Just a quick one.
Is there a similar function in VBA as the isset function in PHP, i.e.
function which returns true if a variable is set.
Cheers

can anyone please help me on this?
how can I use the open.workbook function to open a workbook as read-only or
specifically write-enabled.
any help would be greatly appreciated

Hello everybody!!
I spent a lot of time on a curious bug, and I wanted your advise.
I created a function that must simlpy copy some cells in another range.
This function take a range object as parameter to determine source of

I am volunteering for a non-profit charter school that is trying to set up
Excel 2003 to keep the students lunch money accounts straight.  We have names
and current account balances, and are wanting to set up a userform(s) that
allow(s) a cashier to click on student's name, then ...

Is it possible to print a chart which is in another workbook withou
opening that other workbook?
at the moment i have
Set snagworkbook = Workbooks.Open("Snagging List - 1.xls", False

Hi,,,, solve my headache
I have 2 sheets within excel. i need a formula that will check the
names from 2 sheets, if it has the same name then it will enter into
sheet2 column G the contact number ( Sheet 1 - column C)

I have a sheet that is part of a staffing rota. The hours people work are
filled out by clicking the mouse and dragging it along the row which places
a " " (space) in each cell highlighted and changes the colour to Grey using
VBA. I currently use lookup formulas to find the first ...

Is there any way I can shorten the following code to copy all rows a
once?
Private Sub CommandButton1_Click()
If CheckBox1.Value = True Then

We got well over 100 Excel-Sheets. During the night there is
scheduled task which updates the entire sheets with actual data. Th
Company-Names of those 100 Excel-Sheets is coded directly in VBA (se
below). We use these Company-Names in several modules. This make

I am new to this forum and am an intermediate excel user. I wanted some
help on creating an excel stock screener.
In simple terms I have a list of parameters whose values can be greater
than, less than or equal to certain values. After entering these values