I have the following in Cell B2 :-
LD(24,6,3,6)=163
How can I extract with VBA the ...
24 < this could be 3 digits

Hello, I want a macro to pause to select manually a file, and then format it.
I have attached macro, how to modify it?
' Controller_Openen_decimale_punt Macro
' Macro recorded 7/4/2007 by CROMMENTUIJN Leon

I have a problem when using xlset.
When I try using xlset for fill array of datas. Normally it can work fine.
The problem is occur when I use autofilter feature of excel.
1. I have 25 row * 1 column of datas.

Hi all (again)
Goalpost have changed.
The problem I have to overcome is, I have a database matrix for
X-references. I have added the cross-references as links to the first column,

After I export addresses from our database to a .txt file.
When I open it in Excel
the address fields start a new row like below:
Name

I would like to set an area in spreadsheet e.g. from A1 to maximum
value within the same column.
How to express in vba the following operation? Please help me, I
didn.t find it in my vba manual.

In native VB I get the screen resolution with
 Screen.Width \ Screen.TwipsPerPixelX
 Screen.Height \ Screen.TwipsPerPixelY
And if I'd like to position a window at the right bottom corner I can

I am trying to use an If statement to find an piece of text and then go to
the cell that contains that text. I have, as part of the if statement, an
else statement that just cancels the expression and does something else if it
cant find the iece of text. However, the expression ...

I have a jobs list in a work book named Jobs & Jobs Sheets in a folder called
Job Sheets.
I want to select a job in Jobs & run a macro that opens the job sheet that
has the name in the activecell.

Excel 2002 SP3
I would like to know how to achieve the following with a vba script or macro:
verify if the value of a hyperlink is the same a the value of the cell, e.g.
if the value of a cell is xxx@xxx.xx and the email hyperlink value is

I worte a code to select a range of cells, deselect the last row in the
range then clear the selection's contents. The code is:
Range("E10:Jan").Select
Selection.Resize(Selection.Rows.Count - 1, Selection.Columns.Count).Select

I need help using excel. I have an inventory divided into different
workbooks according to product type, each workbook contains multiple
worksheets for the different providers. What I need is to be able to
access the prices of the different products I have, from a different

Can someone please confirm if this is a problem with excel 2007.
When I manually add a data series to a chart, the new series becomes
the last series in the SeriesCollection object.  When I add a data
series using VBA either by .Pasting or by using SeriesCollection.Add,

I made several worksheets in a workbook which retrieve data from network
database and each worksheet has its own query.
Now, because of so many data, how can I limit to recent date and it should
apply to all worksheets?

After I export addresses from our database to a .txt file.
When I open it in Excel
the address fields start a new row like below:
Name