i have written the following code to hide a column
can anybody help me altering the program to swap between hide and
unhide using the same CommandButton ?
Private Sub CommandButton5_Click()

If an individual LegenEntry has been deleted from an xy chart, is
there a way to bring it back again?
I am finding that the entire legend has to be re-created from
scratch.  Whereas I'd like to just undelete the one absent

I have two work books. One is "historical" data and the other is "update"
data for records in the first. I want to program some vb to update
"historical" with the "update" data. Also I would not be using all the data
in the whole row. I will only be updating certain columns of a ...

I have this code to enter a formula into a cell:
Dim lcell As String
Dim rng as range
lcell = Sheets("Estimates").Range("estdbcboxlnkcell").Offset(estnum,

Hi anyone, I have extreme trouble finding posts I have entered on the
discussion board.  I have tried using the % wildcard and also using my
username, which picks up two of the five I have posted.  This is an
intermittent fault but it is very frustrating.  I have put my name in ...

This Works great if I want everything. However I only want the names in a
specific Distribution List. Is there a way to break this down to that level?
Option Explicit
Public Sub DisplayOutlookContactNames()

Copy down list to variable row?
Range("A3").Select
   Selection.End(xlDown).Select
   Row = ActiveCell.Row

Is there a way to tell if a workbook is open on a network drive?  If someone
has this workbook open, there name will be in sheet1 range A1.  
Is there a statement that can tell me 1. if the workbook is open and 2. the
name of the person who has it open (range A1)?

I have an Excel file with several office data connections. I'm having
minimum difficulty with the data that comes in and is used in various charts.
What i am having trouble with is when i have to manipulate the data as it is
to be presented in a tabular format with formatting etc ...

Can someone help with a problem I am having? I have a button that I want to
click on that will tell the user what months of data are loaded. The months
are listed in individual cells on a hidden data page. My end goal is to have
the user click the button and then a message box ...

This is my second time posting this question ... Please help!
I have 2 workbooks. One consist of a report cover page created with
textboxes, shading, etc. The second workbook has all of my data. I would
like to merge the two workbooks without losing any of my formatting.

Hi -
  Am newish developer.
  Building a large Addin.
  How do you correct a compile overflow error ?

I am working on a large workbook with many worksheets.  The main worksheet
that i have is where i enter all my info on. The heading for the columns are
the months of the year.  on the rows are the dollar amounts. The dollar
amounts I have them flowing into my summary sheets. ...

I am currently using the following code to set the print area in Sheet1 on my
workbook.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
   Sheets("Sheet1").PageSetup.PrintArea = Sheet1.Range("PrintArea").Address

I am trying to open a workbook and "file not found" keeps popping up for 3
or 4 different sheets which are not in this file.  Is there any way of
getting rid of this at start up?  Thanks in advance....
Eric