I am trying to make a macro with user input for counting the difference in
days. I would like to have the user input the start date and finish date.  
Also I would like 3 answers to be given. Answer 1 Count days in 7 day week
which includes weekends (Sat and Sun). Answer 2 Count ...

I have a command button on my UserForm that calculates the values for
FacePlastic_Row, HangRail_Row, and TrimCap_Row.  These values represent a Row
Number where my Part Descriptions are.  If the part is not used it = 0.  I
want the For...Next loop to copy the Parts Description to ...

I have a spreadsheet that looks something like this:
Item     Fac     Type   Oper#     Seq#     Description
AA11     10      R        10           1           FT
AA11     10      R        10           2           108

Here is my code:
Dim wsSheet As Worksheet
   Dim rngNext As Range
   Dim myRange As Range

Hi Guys. I am new to macro programming. Below is my data. I need to write a
loop that will insert new row with same data whenever the quantity is 2, 3
etc. e.g if the quantity is 1,no new row. if is it 2, 2 additional row with
same datas info, if 3, 3 additional rows with same ...

I’m trying to automate a tedious task at work but I’m not sure how to go
about it.
We track daily volumes on a spreadsheet.
Column 1 would have each business day for the month. Column 2 through 8

Hi all, i have a variable number of sheets in a workbook, with variable rows
of data in each sheet. Each sheet has a specific name. I need to loop through
all sheets and get the number of rows per sheet and store the number of rows
per sheet/name on a summary sheet.

hi,
i have the following:
Range("A5000").End(xlUp).Offset(0, 0).Select
the only problem is this is being run when the sheet is in Autofilter mode.  

  Is there a way to programmatically determine the starting or ending
visible portion of an embedded active chart in twips if the chart is larger
than a user's monitor?  I have an application including an interactive chart
that imports jpg images based on a user clicking on a ...

How to set VB code to search the entire active worksheet 1 for error
cell “ #N/A “ and replace one or more error cells “ #N/A” with value
cell  “ 0.00 ” ?
Please help, thanks

How can I change this 04.08.08
to this
04 Aug 08 ?
There are hundreds of rows with dates in this type of date format.

I have been able to create a custom toolbar add-in using vba in Excel 2007
from different examples that I have found on this site. The problem I am
running into is the visual layout of the toolbar. My drop down menu buttons
stack vertically instead of horizontally. Is there any ...

I'd like to set up a macro to combine two seperate workbooks into ONE
workbook.   Here's the scenario.
We make spreadsheets for clients that make purchases from us that hold
relevant information to that specific buyer and save it named "[buyer] -

I am getting an Error on the line indicated below.  FacePlastic_BOM is
declared and calculated in another Sub in the UserForm.  For now
FacePlastic_BOM = 160.
Dim LastRow As Single

Hi Guys. I am new to macro programming. Below is my data. I need to write
a
loop that will insert new row with same data whenever the quantity is 2, 3
etc. e.g if the quantity is 1,no new row. if is it 2, 1 additional row