I'm using this code to copy the values in the last row of column D on each
Worksheet in my workbook (there are 10 sheets) and coping the numeric value
onto a worksheet called Summary.  The thing is neither the WS titles or the
totals are populating the Summary document. What ...

I am a raw beginner at VBA and programming in general.
It  need some help understanding where to place variables and how to
declare
them.

Can anyone send me some code so I can attach it to a button in the tool
bar that will transpose and paste values?
Thanks Sally

The following works:
sub subroutine(optional Byval strVariable as string = "Default String")
Can I do something similar to the following, which doesn't work?
sub subroutine2(optional byval rngVariable as range = range("A1:B2"))

Dear Friends,
I need the macro code to get a ListBox or ComboBox when ever Excel
Application is started and to close the same ListBox or ComboBox When
ever the excel application is closed.

Hello again,
Trying to pull pictures based of a value in a cell. They should be
named the same. For example, in cell C2, the value is A123. So this
process should retrieve C:\Images\A123.bmp However, I receive the error

I need to maximize a program that is in the task bar.  I'm using VBA from
within Excel.  I already used AppActivate but it only works if the other
application is ALREADY maximized.  I also tried using some calls to the
Windows API, but they also would only bring a window to the ...

Hi there, I'm new to this group but I have a problem with Excel. Here
is the code I am using.
Sub AutoFillEquation()
Range("R4:AI4").AutoFill Destination:= _

i want to know if excell sheet is limited in loading pictures ?
i have a work sheet with code thats function to appear the picture whe
i write its name in spacific cell like ("f1")
it works well with a spasific number of pictures but if i add anothe

Hi - I hope this question isnt too newbie. I am trying to copy all of a row,
including all of its attributes like formatting, column widths, etc. The code
snippet that I am currently using to perform the copy is:
wsDST.Rows(DstRow).Value = wsSRC.Rows(SrcRow).Value

How can I modify this code to work on any pic_ in the worksheet
(dozens) without having to enter each one individulally?
Anytime the active cell = the pic_"name" the picture appears.
When I select a name from a validation list in cell A1 I have to hit

Here's my problem:
I want to evaluate the contents of 3 directories while in a macro.  If the
directory doesn't exist, I want to create the directory.  If there are files
in the directory, I want to delete them.

I am facing a problem in intialising a string array in VBA. I need to
intialise an array of 10 elements from data in a range. This range has
text values. I tried to use following.
[code]

I have some code I need to run let's say 10 times on the same sheet.  
How can I use counters s I don't have to retype the code 10 times?
Also, how can I go to the following sheet to the right after the cod
executes the 10th time on that sheet?

I have a spreadsheet, column J has dates ranging from June05 - June 06.
I want to delete the entire row if the date falls between 06/01/2005
and 12/31/2005, and merge all the rows up.
I have tried a few things on here but havent gotten them to work for my