We estimate construction projects for architectural clients, submitting them
as an Excel workbook.  Frequently our clients have few Excel skills and don't
realize that the estimate detail is frequently broken up by project area or
trade on separate worksheets, so they are ...

Here is the situation.  I am writing a routine to generater output
reports.  I have a sheet with a template of the page setup and another
sheet that I am going to transfer that into.  The users can import
multiple sheets of data.  This routine needs to go through their sheets

I have the following formula that offset values from the "Loop 4" sheet. This
formula allows me to offset values every three columns from the same row
(17). Therefore, this is what I have typed in my cells to call this data:
=OFFSET('Loop 4'!AM$17,0,3)

Hi! 2 weeks effort down the drain unless you have an answer...
[Office XP SP3 running under XP Pro, SP2, 1GB mem)
I have written VBA in MS Word to generate a concordance for a book <=100k
words.  Because of bookmark limitations in word (max ~16387) I have written

I wished I could do this in Access, but I'm the only one in the dept
who has it. And, what I'm designing will be used by others. So, I have
to try to do this within Excel.
The user will flip through a report at the end of the day. He will

How do you extract a certain character from right to left?  This is so
simple, yet finding any help code takes me to a million other examples.  
Thanks.
1164NB1

I am trying to link one spreadsheet to another using a common Find text box
that will locate an instance of a string.  Basically I have a inventory
spreadsheet that contains all of the possible parts, and I also have a
on-hand iventory of what I actually have.  I am trying to ...

Hi, I'm rusty on VBA and I tried mimicking a few solutions already posted but
I couldn't get them to work.  I am trying to create two separate macros.  
Macro 1:
I would like to delete rows that contain the text "Total" in Column A (e.g.,

I saw an Excel application today with terrific graphics - Userforms with
rounded graphics , unique controls etc. Anyone know of such an add-in
for Excel?  Searched high and low on Google with no luck.
Cheers

Hello, I just switched to a new Desktop at work with Excel 2003.  My
Intellisense property lists do not appear in VBA and I am having
trouble finding out how to activate it.  Any suggestions?  Thanks in
advance.

I have a workbook that, on sheet1, I can select options from a bunch of
list dropdown boxes. This in turn changes the size and contents of
several named ranges on another worksheet (say sheet6).
What I need is a macros with command button on sheet1 that will take

I got a VBA script from this group to import files with VBA and it has
worked like a charm until yesterday.  Now the processor stays pegged @
100% utilization when running the script and the import takes forever..
I thought it was a samba issue since I was pulling files from a ...

How do i require a user to enter a data in a field in Excel?

I am using the refedit control on my userform.  That works fine.  I
would like to see something other than the cryptic value that it
passes.
For example the value that I get from using refedit is:

Private Sub CommandButton1_Click()
Dim ctr As Long
Dim StartNum As Integer
StartNum = 0