Is it possible to assing a macro and/or button to open the VBE?  I know that
seems a little redundant, but I need to try.
Thanks to all.

I have a userform where users input their name, department, phone#, fax# and
email.  This information is input into one cell on a worksheet. The cell is
formatted using chr(10) between each. I want to be able to edit the user
information by breaking it back out of the cell an ...

I have multiple merged cells, each with any of 3 possible colors.  When
I use the countbycolor module, it counts all the cells in the merge
area.  What I want is to count the merge areas, not the individual
cells, by color.  Any hints?

Is there a way to locate any subs where code in another sub might be
called?
Example: There  have been situations where I have a sub that is now
obsolete, and I want to make sure it is still not referenced in any

how can use VB to design one program that only allow other people onl
open the workbook 10 times, 11th time when he open the workbook the ms
shows "over the use limit, contact owner".
than

I have two possible requests, which ever is easiest will be the best choice.  

A macro I'm working on opens up extra work books for the purpose of pasting
various filtered data (it's fairly complicated, was the only way I could

I've got a database with a ID--such as TC38493--in column A, but not in
every row.  Instead its the ID followed by more information about that
ID. And the information is contained in more then one cells in the rows
below it.  Unfortunately the number of rows of information is not a

I want to automate a manual cash flow projection process in excel.  
Currently, the daily cash receipts forecast is manually keyed in.  I want to
automate this and have extracted data from our accounting system complete
with customer number, due date and value in sheet1. The ...

In a textbox in my userform only one @ is allowed. How can VBA see the
second @ and delete it?

I had a loop that worked just fine. Then I added an extra IF-Else and the
computer started complianing that I had loop without do, which is untrue. Can
anyone see whats wrong with this loop?
If rng1 Is Nothing Then

Hi I think there is something wrong with "For Each wks In
ActiveWorkbook",
any help is much appreciated.
Sub taz()

Hi. I want to compare the data in two different variables. I does not seem to
manage since one variable is encapsuled i.e. "55518" and the other is plain
i.e. 55518. I have defined one of the variables as Variant but it does not
help.

I want creat a macro which i want use delete my selection every second coulm.
   A_col     B_col      C_col
1
2  <----- want delete

Is it possible to force a change to a parameter in nested loops?
In other words, I want to compare two cells in different rows and, depending
on the result, restart the loop counter from a different position.
e.g.:-

Hi. I am trying to make a loop in which I want to search for 1) The word
"Date" 2) If this is found I want to check the cells in the same column but
different rows than "Date". This is to check where the list ends. However
when doing this check I want to compare a predefined ...