I have a worksheet with a column of "pictures."  All that the user sees
is the text Picture, with that text hyperlinking to an image on a
network share thusly: "file:///\\server\share\imagename1" or
"file:///\\server\share\imagename2", etc.

In a macro, how can I make it show the position of the Active Cel
(Column/Line).
Or how can I set that position as a Condition; e.g. “If ActiveCell i
B7 Then….”

How do I assign a font change to selected charecters within a cell.
Example:
A1: 623154 (as text)
I highlight 231 and run the macro and get this result

Can I initialize the % sign as a variable in code to identify and use to indicate the user id of the user who is running the code on
their station? For example X = %. or something like that.
Thanks,

I used to program in Quattro Pro a long time ago.
When I wanted to debug a Quattro Pro macro, I was able to start the
macro (I can't even remember which command that was) but then I could
hit the space bar and I could see the macro execute step by step.

I'm new to writing macros and need a little help. I'm trying to write
macro that will hide/unhide different rows within a worksheet. Fo
example, I want to check a box and be able to hide rows 8, 10 and 12
but leave rows 9 and 11 alone. Thanks in advance for your help

I'm trying to figure out how to display this programmatically for the user.  
I want the user to enter a date between the following two dates:
Date 1 is defined as SummaryMin
Date 2 is defined named variable CPI_SPI_PITD_LastMo

I want to set an expiration date for a worksheet.  I'll store the date in an
xlveryhidden sheet in a cell.
Can someone help with the code to check the cell and compare to now, and
goto a sub to hide the other sheets?

I have some data being exported daily from SQL into Excel. A pivot
table is applied to the data with the columns of the table being the
WeekEnding dates. Although the field format is "date" in both the raw
data and the pivot table column, the pivot table is sorting the columns

I have a large spreadsheet with at least 6000 records (rows) and 5 columns.
The columns are as follows:
  B5           C5         D5     E5      F5
Check#  Vendor# Name Date Amount

Any help would be appreciated.  I have a workbook with several
spreadsheets that contain small picture files.  Each time I open the
workbook I would like a macro to run on each worksheet and resize the
files to a specific size.  The code I have so far is below.  It only

With Worksheets("SpeedPlay").Shapes.AddLine(546, 90, 546, 114)
.Line.ForeColor.RGB = RGB(0, 0, 0)
End With
The preceding Macro code adds a black line of a certain length and in a

I'm trying to import a workbook into an open workbook using the code
below, however, the workbook I'm trying to import has a password.  The
password is blank (essentially no password).
Sheets.Add Type:= "E:\mattw\My Documents\My Timesheets - 2006.xls"

My macro generates a Sales by Product by Customer PivotTable with 3
columns i.e. Product, Customer and Total.
Automatic subtotal are generated at each change of Product (Column A)
I then insert the following Conditional Format in the entire

I want to change the color of a cell with conditional formatting.That means
the
cell color     Value
Red             0-97