Copying only cells with data in them
Wed, 27 Aug 2008 10:52:10 -0700
I am trying to figure out a way to write a code that will select and copy
only those cells within a selected range that have data in them, and to
suppress those that are empty.
The information will eventually be "paste-special-ed" into a word document,
such that automatic updating is possible.
I'd appr ...
|
Capture InputBox vbCancel
Wed, 27 Aug 2008 10:41:01 -0700
Hello, I have the below code that prompts for the qty of rows to be inserted
but when the Cancel button is selected instead of providing a number and
clicking OK I get an error. I was hoping that putting the IF statement in
there would fix it but it did not. How can I fix this?
Thanks in Advance.
Sub A ...
|
Code Stopped Working
Wed, 27 Aug 2008 12:04:11 -0500
Greetings,
I recently broke a worksheet off of a large workbook and made it into
a single sheet workbook. I kept the sheet code for the clearing
process. This code is located in the sheet code area. After clearing
all entries the code changed the color of a button and two cells (to
announce that it has fin ...
|
Import Data from Multiple Sources
Wed, 27 Aug 2008 09:25:01 -0700
Hi,
Iâ??m trying to import data from the last sheet of multiple workbooks into one
of five predetermined worksheets in a new workbook. I havenâ??t seen anything
on how to do this in the newsgroup and it doesnâ??t appear that I can use ADO
to accomplish it, so Iâ??ve plagiarized Ron de Bruinâ??s code to this p ...
|
Disable Format menu
Wed, 27 Aug 2008 09:23:01 -0700
This code disable Format menu (whole menu)
Application.CommandBars("Format").Enabled = False
But im just vana disable Show (Format/Columns/Show or (hide)
hav do i do that ?
thanks in advance ...
|
Where is the "Eval" function located?
Wed, 27 Aug 2008 09:06:58 -0700 (PDT)
I'm doing some long-overdue code cleanup, breaking down one large XLA
into a series of smaller ones. During one of these moves, one module
will no longer compile because it cannot find the "Eval" function. I
seem to have the same References list for both, but I guess I don't.
Where is Eval located?
Maury ...
|
Toggle for Macro
Wed, 27 Aug 2008 09:00:02 -0700
I have a worksheet that contains (50) identical estimates with one following
the next down the spreadsheet. Each estimate is (24) rows long. AT the top of
the worksheet is a single summary that shows the cost value for each of the
detailed estimates below. I also use the summary to navigate to each detail
es ...
|
|
|
I need some changes in a code
Wed, 27 Aug 2008 08:59:13 -0700 (PDT)
A good day to you all
I have the next macro :
Sub Scenarios ()
' This macro return the combination of 30 things taken 5 at a time
' The 30 individual piece values are assumed to be in cells A1:A30
' AAA will place the various combinations in column C
' Warning : the values of A1:A30 , is better to be not ...
|
make a list of the listobjects on a worksheet
Wed, 27 Aug 2008 08:58:25 -0700 (PDT)
Hi,
I am sure this must be easy, but somehow I'm not "getting it" today.
How can I generate the names of the list objects on a worksheet?
This is close, except it gives me the count:
Sub test()
Dim i
Dim LObs
For i = 1 To Worksheets.Count
LObs = LObs + Worksheets(i).ListObjects.Count
Next i
MsgBox ...
|
Copying Form Fields to Log
Wed, 27 Aug 2008 08:44:59 -0700 (PDT)
I have an Excel form file with 10 fields that I send to different
customers to complete. I can't link the cells because I am sending
them to outside companies.I would like to have a log that summerizes
all of my received files.
for example,
my form would look like this...
Name: Joe Smith Company: ABC C ...
|
