How do I use the SUM function to total amounts from one sheet to another
within the same document?

This is my code:
-Sheet4.Range("A3", Cells(l_LastRow, l_LastColumn)).Select-
I get the error message: "Method 'Range' of object '_Worksheet'
failed"

Hi, Thanks to an earlier thread I have the folowing:
=countif(a1:a100,"")
but I need to vary the formula with the no of rows per data.
so if Row 123 is last row

I have a long list of data I would like to print on less pages.  How do I
make one long column, print out as two columns on paper?  I do not want to
cut and paste into a word document.
I saw this question stated, but the answer was too complicated with jargen I

Short question: What am I doing wrong?
I have a range of cells:
The range of cells (C22:ap34) is populated by the formula:
=INDIRECT(C$4&"!E"&$A22) thru =INDIRECT(AP$4&"!E"&$A34) - this created

Need to delete multiple items that are on all sheets of a large
workbook...Help!

A quick question...
I want to create a pivot table that provides sum of fields, but the column
that I'm using contains blank fields, and the the pivot table displays these
as blank, but still takes the sum of these fields and adds them to the

how do you format a cell so that when you enter 1254 the number is displayed
as 1,254,000

I have a problem with splitting up the target figures for the year.
We have a number of objectives to meet over a year some are high figure
(150 cases per month) others are very low (as low as 4 cases per year.
I need to develop a spreadsheet which will allow me to present both the

How do I make the page numbers like 1 of 30 run consecutively

I am attempting to import a simple text file into a workbook to allo
it to apply the information to cells and print.
Sub load()
'

I need a formula which counts blanks within the range b1:b200
Ive tried countif(b1:b200,0) or countif(b1:b200,"0")
neither work, any help is much appreciated

Employee Name Date    Monday In    Monday Out Tuesday In Tuesday Out    Total
                   7:45 AM    4:15 PM    7:45 AM    5:00 PM    8:45 AM    0:45
I cannot figure out the formulas.

I want to convert Arabic numbers to English Text format (Similar to BAHTTEXT
option).
Ex. 1,234  to be given as "One Thousand Two Hundred and Thirty Four"
Is it possible to do so using functions that are available in normal

I need a formula to calculate a floating date - the last Saturday in
September
If found this formula on another site, but couldn't seem to get it to
work.