I need help please! I have a worksheet with multiple rows/columns of data. I
need to look at the text in each cell in column B (which is already sorted
alphabetically) and if a cell is repeated, to display only the rows in which
the cells in a column are duplicates.

Hi,
I'm new to macros. How do I create a macro that sorts by Column A, inserts
two new columns after column B (i.e. they will become column C & D) and fill
column C & Column D with these formulas down to the last row in the current

I have two worksheets with the same information in columns A,B and C. My
second worksheeet has hours worked in Column D. What I would like to do is
have a formula that states if columns A B and C are equal in both tables to
have the result in column D in my seocnd table to appear ...

I have another question.
I'm comparing two pairs of columns (Column D with E, Column F with G. The
data in these are vlookup-ed from other sheets) and putting down the
comparison results in Column H.

I need to center text in an autoshape oval's text frame.  It works fine in
Excel 2007 by using the text frame and inserting a single letter as a
character with no additional instructions.  However, after loading it at work
in Excel 2003 the character is barely visible in the ...

I'm fairly new to this & I've read a couple of similar posts but they don't
seem to answer my question fully. I am importing a csv file (c:\nlexp.csv)
from our Dealer Management system on a daily basis, however, if the export
from DMS is run more than once in the day, the ...

Hello I'd like someway to figure out if my loop ends up on a new page, and I
was wondering if there was a check to see if something is on a different page?
For example I was thinking of something along the lines:
dim pageAt as Integer

Dear Experts,
You have always helped me whenever I am in troble. so I am again here for
some help from the experts of this fantastic discussion board.
I have three columns as give below:

The resulto of the code
   ActiveCell.Formula = "=" & (Cells(11, Sheets.Count + 1))
is : =
But, I need it to be equal to :

Hello all, i have to loop down a sheet in column "L" and for each cell i need
to calculate "=(J12-H12)/30.5". Is it better/Quicker to do the calculation in
VBA and then insert the result in applicable row in in column "L", or is it
better to loop down and put a calculation in ...

I've been assigned a task to write an Visual Basic .Net  application that
read data from an existing excel file and uploads the data to an SQL Server.
The excel file itself is not a VSTO application, nor does it use VBA code.
I know I can save an Excel file as a tab delimited ...

I'd like to declare a workbook and a worksheet before the first
procedure so that all other procedures can use them.
When I tryied to use Set Statement as "Set myBook =
Workbooks("test.xls")", I've got "invalid outside of a procedure"

I have a very large worksheet with about 110,000 rows, and a VBA
program that analyzes each of these rows, comparing their values with
other sheets in the same workbook.
In one Sub in my program, I have a For loop that I expect to execute

Is it possible only with "find & replace", put a string before the same
contents ?
I mean:
- I have 50 cells contains only 2 letter ("AA", "BB", "CA", ...)

I maintain an add-in on my employer's shared drive.  Currently, when users
who have installed my add-in launch Excel, the add-in deletes its toolbar and
rebuilds it to ensure they are alway using the most recent version.  
However, the code is not remembering the previous location ...