I am trying to create a macro that looks in column G. If the value in
colum column G is greater than or equal to 50 then I want the macro to
take certain parts of the line and puts into another workbook. I have
about 50 lines that I need it to look through and then quit. How would

I am trying to write a macro that will insert values from different cells
into a sentence. The problem is that not all cells will have a value in them.
Do you have a suggestion that does this? Here's what I mean as an example:
Cell A1: paint

Is there a way to prevent someone from saving over a specific file?
I've created a file on a network drive for some users.  Some of the users
complain about the time it takes to open the excel file.  What they've done
is save the file to their C:\ once the file is open.  Make ...

I have several variables named RandRow1, RandRow2, etc. that have been
populated with values. How do I convert a concatenated string into an actual
variable? In this case it's RandRow & i where i = 1 to 10. Thanks.
Dim RandRow1 as Long

I'm looking for a macro that will take a column of data that look like
this
B. Tallackson (1)
I. Pikkarainen (1)

How do I automatic sequncing this numbers

does anyone know how to use the indirect and offset worksheet function to
return the value of a cell base based on a where the vlookup value is found
on a work sheet

Hello. I'm attempting to cycle through an array, looking for a color (sPat).
If found, return the corresponding iColorIndex number. For example, if sPat =
"Dark Red", then iColorIndex should be 9. Where am I going wrong (probably in
the variable types)? Thanks. Jason

I am creating a word document using Excel and I need to add a hyperlink at a
given position in the text. For some reason the following code does not work.
WordApp has already been dim'ed.
With WordApp.ActiveDocument

I was trying to do the following (to get away from the select) but am getting
a "variable not defined" and it is highlighting xlInsideVerticle,  or (if I
take out xlInsideVerticle) error msg " wrong # of variables or invalid
property assignment" and  .Borders  is highlighted,     ...

How do I write a code that will send each sheet in an Excel work book to a
users name that will appear in A1 of a sheet.  Each sheet must go to the user
that that sheet is assigned to.

I have a spreadsheet set up with a few macro buttons and I was looking for a
way to protect those buttons so that only certain users would be able to push
them.
Is there any way to do this?

Using the PIAs I am exporting a third-party grid to Excel from .Net.
The grid's export functions require an Excel sheet to be saved as a file --
there's no way to save it as a stream or load it directly into Excel. So I
then invoke Excel and bring up the saved file. But I would ...

I have been given code of:
Do Until Selection = ""
       If Selection Like "A*" Then
           Selection.FormulaR1C1 = "AL"

I am relatively new to programming.  Can anyone suggest the code for the
following:
I want to highlight each row that contains a certain value in a particular
column.