Count anyone shed some light on this issue.
I am using the statement
n = WorksheetFunction.CountA(Cells(i, 13), Cells(i, 17), Cells(i, 22))
I am trying to get a value for how many of the 3 cells have data in them.

am trying to vary the name of the lookup range depending o the result
of a 2nd lookup --
NYC            =vlookup(A1,range1,4,0)
LA               =vlookup(B1,range2,4,0)

Data Entry Outsourcing Services ensures high quality, result oriented
in time. We promise to deliver excellent output at low turn around
times and cost-effective rates. Our dedicated team of highly
experienced professionals to provide you high quality outsourcing

Is there any way to 'flip' a worksheet with one command, so that columns become
rows (or rows become columns)?

I am having problems trying to create an excel template.
I took a xlt file.  and put it in the dir
C:\Program Files\Microsoft Office\Templates\1033
However I do not see it ever showing up in the

I am looking into purchasing a data logger that will collect voltage,
amperage with a time scale.
Below is a sample of the data and a summary to be generated above the
data. I have some problems with how I can have a msexcel spreadsheet

I am having difficulty with figuring the percentages of 2 cells for safet
stats. Its been a long time since college, anyway if E9 is 35 and F9 is 1 how
do I get the % of the 2 cells to enter in  E10

How do I make a rule that an identical number cannot be entered twice in an
Excell column?

My Excel VBA is sometimes used by other people, and they ara "abusing" my
codes by using toolbar commands. I want to make Excel VBA and to hide /
disable all toolbars and any other Excel  command. I want that only my
buttons can be used.

Does anyone know of any way to increase the number of rows displayed in
Autofilter, becauase when working on large ranges it doesn't display all
values.
Any help greatly appreciated.....

Hi - how do I add 'SAMPLE ONLY' diagonally across a tab and have it somewhat
transparent?
I've tried pasting in a jpg of SAMPLE created using Viso, but that
background of the pic is not tranparent.

Need a little help: I have projected sales by item listed in 52 columns
for the 52 weeks of the year. I also have a total available Finished
Goods inventory column along with a column of Finished Goods on order
and the date these Finished Goods will be coming in to our facility for

How can I delete multiple rows that have the same entry? Example if I filter
by a certain zip code   can I delete all without deleting other info?

I have a worksheet (excel 2007) which has 14 columns. For reasons I do not
understand there seem to be several hundred extra empty columns to the right
of my data. Whenever I try to print, the program wants to print far too many
pages. What have I done ?

Is there any way to 'flip' a worksheet with one command, so that columns become
rows (or rows become columns)?