I am using Office 2003 on Windows XP.
Drawing borders around cells seems so code intensive. Is there a shorter way
to accomplish the following (which simply boxes a range of cells)?
PLEASE NOTE: I tried "BorderAround," but this does not add the "inside

I have a worksheet that contains a cell that I enter in different
company names such as (Costco, Sams Club, Jack n the Box).  Each of
these companys has a seperate worksheet with their addresses that I
want to lookup.  My question is:  Can you create a macro that takes the

I am in the middle of writing a macro that runs on any change to a specific
cell containing a validation list.
I tested that it worked with each bit of extra code that I added, and it
worked fine for a while, but then it started to crash Excel and I cant find

I need data from Access. The Access query is based on a table that must be
created first using a Make Table query. How do I run this query from Excel
VBA?
I tried:

I'm sure the answer to this is straightforward, but I can't find out
where I'm going wrong! I've done a bit of VB in Excel but it's all been
very simple.
I've followed the "Create User Form Turtorial" from this site and

I have a worksheet with cells in column A containing text only.  I need to
locate each instance of [Zx] and replace it with [Znumber].  For example: In
cell A1 the first [Zx] substring needs to be replaced with [Z1].  The second
instance of [Zx] needs to be replaced with [Z2].  ...

Does anyone have a function or know of an API call to determine blank pages
in print preview in Excel?
Many thanks,
Yemi

I dont have much expertise in VBA but trying to learn.
I am trying to import multiple csv files into excel. I have a macro
from this forum to import the files one by one. But I want to be able
to select and open the multiple files at once. Also with the macro that

I have a excel sheet with 3 sections and i have setup the "Row to
repeat at top" to a row in the pagesetup.
how do i go about removing the property(Row to repeat at top) in the
page where the second section ends progrmatticaly.

i have a set of UDFs which often take a long time to calculate.  they
go to SQL Server and upload and download requests and do a lot of
processing.  Since they take a long time, i would like to provide the
user status information, such as how many requests have been downloaded

Is there a way of referring to an active selection of cells in vba, like
you can activecell for an individual cell?

I have three macros in my workbook however I only want these macros to be
allowed to run if the workbook is protected by being read-only.
This would mean if any of the macros run then it would check to see the
status of the workbook first - could anyone advise how to acheive this?

I have around 30 textboxes in my Excel 2003. and were created by
=EMBED("Forms.TextBox.1","")
I wonder how I can loop through them using VB within Excel. I have
tried

In my Excel 2003, I have around 30 textbox, which is created by using
the following formula
=EMBED("Forms.TextBox.1","")
I wonder how can I loop them through my VB editor within excel. I have

Does anybody have any idea about how to trap the window scroll-bar
events and mouse scroll events for an excel sheet through VSTO?
We can also make do with any events related to change of visible range.
We are in real soup now. Any little help will be appreciated