Range("A16:C16").Select
I would like the above command to select columns A:C with the current cursor
row.
Obviously a Macro newbee, lol Thanks for any assistance.

We have a spreadsheet into which we dump a large amount of data (averaging
around 55,000+ rows). We then use formulas to detect error in the data so
that we can go back into the original program and correct those errors. What
the code below does (my thanks to Rick Rothstein, MVP ...

Excel's Help states:
"Microsoft Excel will change the row height of the range, if necessary, to
accommodate the text in the range."
Using the following, the row height does not change:

I'm sure this has been posted before, but searching the group for
instances of "this" has proven to be a daunting task.  :-)  Do any of
you know if there is the equivalent of a "this" pointer in a VBA
class?  That is, a reference to the current instance of a class?

I have a data set of employee numbers.  the numbers range from 1 - 6
characters and can be all numbers or have letters.  I need to compare this to
another worksheet but need to convert the EE numbers to text and all must be
6 characters long.  So I need to do the leading zeroes ...

Does anyone have any suggestions on how to exit the loop if mycell.Text =""?
When myCell.Text is equal to "", the loop keeps going, but I would like to
exit the loop if myCell.Text is nothing or "".
Does anyone have any suggestions on how to code it?

I want to use the Workbook.Activate application event to detect when a
worksheet has been activated, and then depending on which one, do something...
I have seen reference on this site to catching this event in the
"ThisWorkBook code module", but I don't know where that is. I ...

Does anyone have any suggestions on how to code macro with if condition?
My code:
myCell.Offset(0,3).Value = Sheets("Temp").Range("B15").Value
If Sheets("Temp").Range("B15").Value contains "B" character, then delete "B"

I would like to compare an active cell with another cell and dependant upon
whether the active cell is greater than, equal to or less than the
comparision cell I would like to set the fill colour of the active cell to
either red, white or green. Any help would be appreciated.

I've created a workbook where a group of cells from one worksheet (worksheet
B) are populated by way of a link to another worksheet (worksheet A).
Worksheet B also has manual input in the column next to the columns that are
linked from worksheet A. When worksheet A gets sorted ...

Does anyone have any suggestions on using substitute function in macro?
I would like to remove any "B" character within the return value from
Sheets("Temp").Range("$J$15").Value.
------------------------------

I have received a "chaotic "sheet coming( presumably) from inorderly and
faulty mergers from different source sheets ( who are lost...), from a
collegue,  to restructure it into an orderly one...
I work on Office with excel 2002

Please help.....
A serious reportable error prevents me opening a developmental xla which has
taken a long time to write and the only safe copy I have is several days old.
Converting it to an xls still does not get me anywhere.

This post follows on from Dave Peterson's reply 13/3/08.
I replied twice on the 14th but they seem not to have posted.
Dave your code will be good if I want to just see unique values but
can I please get some help to highlight all rows where col C LastName

in office 2003 you go to start, all programs, microsoft office tools.
but how do i create a sertificate in 2000?