I only want to code a line which instructs VBA to
Place a thin border around a cell.
With Range("G2")
       .Range("A1").Formula = "=SUBTOTAL(9,$G$5:$G$50)"

How can we remove outliers in a time series using MS Office Excel or Eviews.
What are different methods and how efficient those menthods are?

I had a macro sent to me to use in EXCEL.
It was saved to a specific worksheet, say "sheet 1".
I want to move or copy it to the PERSONAL.XLS so I can see it whenever I
open any EXCEL file.

Hey all,  I submit a time sheet each week for the different jobs I
have worked on.  I am trying to make a spreadsheet to totalize how
many hours I have spent on a single job over the course of a year.  I
have all my time sheets in one Excel file on multiple sheets.  How can

I have a formula in Cell D5 on SheetName Formulas as follows:
=IF(MID(E5,LEN(E5)-1,1)="A","Kel Tech",IF(MID(E5,LEN(E5)-1,1)="B","South
Star",IF(MID(E5,LEN(E5)-1,1)="C","White
Rodgers",IF(MID(E5,LEN(E5)-1,1)="D","GRI",IF(MID(E5,LEN(E5)-1,1)="E","Graybar",IF(MID(E5,LEN(E5)-1,1)="F" ...

I would like to be able to return the data label as well as the value from
the last point of a series collection on my chart.
Now I can use this code to find the end point in my series collection
P = ActiveChart.SeriesCollection(1).Points.Count

i am just looking for a short description, no code,  on how you would proceed
with this task. i have an idea, but just wanted some other input before i really
got into it too far.
looking to summarize spice blends. every blend is in a separate workbook whose

I have never attempted to write VBA code, but would like to know how to
import a report with data in a text file that is stacked that I want to
import to excel on one line in columns. Can someone help with this?

This a 2 part question, both involving filling a listbox on a worksheet.
1.) How do I have the listbox have multple columns and have the data source
be B2:D12?
2.) How do I have a worksheet listbox populate from an un-opened workbook?

I have a code to show different rows of a worksheet that asks for a password
when the workbook is opened as follows:
Option Explicit
Private Sub Workbook_open()

We are trying to copy a Range to another worksheet in a C# Excel 2007 add-in
and want to get everything from the source range, including the cell formats
and formulas.
Our code is:

I have prepared a code below to display one of 3 different pictures to
show high or fair or low performance. This code works fine for one
condition input which is at cell A6.
The problem is I have another 15-20 independent conditions (cells)

I have a worksheet "Report" that is populated with revenue and expense
information by referencing a pivot table.  When I select a new pivot
table page (department), the proper accounts and amounts appear on
"Report".

how do I control userform2 on close to show userform 1
Thanks

I've searched the archives here but have not found a suitable answer for this.
I want to be able to execute two commands from the same button.
When the button is pressed once Columns B:D are hidden and when the button
is pressed again Columns B:D are unhidden.