I have a Text Box in a User Form that I am creating.  The Text Box's
value is set to a number without decimals.
For example:
Dim rents As Long

Tengo el siguiente macro que alguien me lo dio en algun momento que
estaba necesitando:
Sub concatena()
 Dim celda As Range

2003
In addition, the best way to separate the Sheetname from the Cell
reference from that SubAddress.
Any thoughts appreciated!

I have two sheets in a workbook (Sht1 & Sht2). I have a list of names
in column A of Sht1. I want Column A in Sht2 to mirror Column A in
Sht1. I entered "='Sht1'!A2" in Sht2 cell A2 and this works, but if the
cell in Sht1 is blank, then the cell in Sht2 displays 0.

I have an application that spits out a comma-delimited csv file. The
file is plain text without any strange characters that can't be read by
say Notepad.
When I open this file in Excel, it converts to a spreadsheet format

Howe do I start running a macro?

When I right click on the Excel spread sheet, functions like CUT,
INSERT are greyed out. Can anyone help????

I have a workbook that has 12 spreadsheets (1 for each month).  If the
user changes a heading title in January's "Category" row, all of the
months update to use the new heading title.  I'm doing this by using a
simple formula in the other month's sheets:

Is there a way to make a graph in Excel "float" on top of the sheet that it
is in, so that I can scroll across the data, and still see all of the graph.
Thanks,
Rob Lepper

After setting up functions, the spreadsheet appears ugly when there are
empty input cells.  Is there any method in suppressing the display of
#VALUE! etc, say assigning white colour to these error words?  Thanks!

Hello, I have a column of 1000+ rows, each row containing a 1 or 0. I am
trying to find a formula that locates the cell range of the largest sequence
of ones and use that range to sum the same rows in another column. The
largest sequence of 1's may occur a number of times. For ...

Not been around for a while so not even sure how to ask this...
I have a spreadsheet consisting of 3 columns, column 1 is text, col 2 is
a pseudo date, Like (aug 23) no year shown. colum 3 is a numeric value
which can be either + or - shown as 12.35+  or as a negative 345.82-

I have drawn several lines, curves etc on an excel spreadsheet and would
like to give them a specific name rather than Excel's defined name - is this
possible?
Thanks!

Using       =If((A3=A2),"X","O")      It assigns "X" for the A2 and and
"O" for the A3. How can get it to also assign an "X" for the A3?
Thanks
Mickie

I'm trying to format a cell to enter the date i.e. 6/12/06 dd/mm/yy
but when I format it custom dd/mm/yy it shows up as 11/03/40?
-Rich