I want to write a macro that need to fetch the particular column of one
workbook to another workbook.

I have an excel 2007 workbook with many tables linked to sharepoint lists.  
In all, there are over 30 data connections, each containing a separate query
which Excel dutifully embeds in the workbook (under the connections.xml file).
The trouble is, about 3 of the tables refresh ...

I have a sheet that contains a lot of cells with data validation. I'm
wondering if it's possible to know in VBA if a specific cell is correct or
not?
Thank you!

I have the following code that is used to prompt a user to save the current
file:
fname = Application.GetSaveAsFilename(FileFilter:="Microsoft Excel Workbook
(*.xls), *.xls")

I am looking for a formula function or a vba code where:
- In workbook1 find the first cell that is empty between range A7 -
A10,
- In workbook2, in Range G10- G13: find the word "Day1".

I'm using vba with ms project and excel, pulling the tasks from project to
excel.  I have excel 2007 and 2003 installed on my computer.  By default
when I use
Set xlApp = New Excel.Application

I have a row of 12 000 cells, but i want to use just every 4th cell, for
example:
A1
A2

I have an obscure problem.  I have simplified it down to the code below.  I
am trying to create a named range with VBA but the range name has inverted
commas around it so it will not work.  For example, the code below creates a
named range for ResourceList of:

A little Help here...I can't figure it out.
I have one sheet in my workbook called DATA.  On the DATA sheet, I
enter the Last Name in Cell C3, I enter the First Name in Cell C5, I
enter the middle name in C7 and the Worker ID in W3.  After these

I'm using this simple code to copy and paste values from one sheet to
another but for some reason I can't figure out how to move the
DestRange1 down one row. I'm pretty sure it's Offset but I can't
figure out where to put it...

I have an Excel worksheet template with formats, formulas, etc.
I wrote code to automatically copy the template worksheet, then assign a
name to the new worksheet. The code references a list of 56 names to loop
through in creating 56 worksheets. However, after creating 16 ...

My macro calculates a large range. There are certain cells in that range that
I don't want it to include in it's performace, but I'm not sure how to get it
to skip those cells. I've tried using multiple ranges, but if I add a row
onto the worksheet, I then have to go into VBE and ...

I've been working on the code below which is in "ThisWorkbook". I
edited the if statements down toward the end, and now the macro
doesn't trigger when I change a value in the sheet. I'm confused,
again!

I have a question about using Querytable to download the data from
website, the code is like this, the question is: Is it possible to
export the data to some variant or array defined in the VBA, instead of
the worksheet. Since if the data has too many rows, then worksheet is

I am trying to find a value within a group.  I have a spreadsheet that I
have formatted and sorted so that it looks like:
Group    Prod    Name    Amt.
a    123-33    chair    37.5