I am new to VBA. I wonder if there is a marco which I can use to copy
all the nonblank rows from many worksheets and paste them onto one
single worksheet (as text). For example, say I got sheet1, sheet2,
sheet3 and I want to copy all the nonblank cells (except the first row,

I want the same header, footer and column headings on about 8 sheets, but I
can't seem to get it to work.  If I list just one page in the string it does,
but if I list all the sheets, it does not. Here is just a section of my code.
What am I doing wrong.  Thanks for your help.

how can i put the following 2 vba together, so when the workbook expire
or over the limited, it will be deleted from the system?
1.
Option Explicit

I posted this question on the bottom of another thread but I am not sure if
anyone looks at threads that have green tick against them as they look as if
they have already been answered.  I have copied the original thread and my
extra question below, could anyone help please?

I am populating an MSFlexGrid with rows of data manually on click of a
button....so it looks like the following:
Code:
--------------------

Is it possible to define the length of an array using a varaible. I have
tried:
Public blnCheckBoxArray(intNumberCheckboxes) As Boolean
but I get error message saying that a fixed value is expected. I ought to be

On an Excel worksheet, one can select multiple non contiguous cells with the
Shift an Ctrl keys. But is it possible to remove a selected cell from the
selection without having to redo the whole selection process?
Thanks.

I have the following two macros in Excel. The only thing is they take a
lot of space and time to type, because below I have the first three
objects, but it will have to be 250 objects! So can somebody help me
rewrite these two macros so that they will be a lot shorter? Thanks in

I have the following code that works fine and does what I need it to do. What
I am wondering is if there is a way to improve the code inside the if
statement so that the 2 workbooks do not need to be alternately selected.
Thus I hope speed up the macro.

In a textbox of my userform only the comma and digits are allowed. But, the
user must not be able to make long entry: such as 1,65647. Only two digits
AFTER the comma are allowed. Digits on the third position must be deleted.
Can someone help?

I have a validation drop down box for a cell. Let's say the valid values are
"BLUE", "Red", and "YELLOW".  If I type in "blue" (lowercase), I want the
cell to find the value and display it in the correct case (i.e., "BLUE").
If I type "RED", I want the cell displayed as "Red"

Combination of TWO
===============
I have four basic numbers 1 2 3 4. If I have to make all possible
combinations of TWO out of these four basic numbers, then the answer

Hello! I got this piece of code from someone who helped me with a function
that counts the number of textboxes in a user form. However I do not not what
what 'oUF' means and how to use the function. I have never used functions
before so I do not know how to call it. I tried ...

For testing purposes i want to control a workbook from another workbook
with vba.
When setting a checkbox to 'checked', the macro assigned to the
checkbox is not executed.

Is it possible to have a progress bar that pops up on the screen on to
generate an equivalent using a worksheet/tab to inform the user that
the process is running and to be patient while a set of macros run in
the background? Thanks in advance