How can I populate a ComboBox with the columns of a range selected in a
RedEdit?
Thanks in advance

I want to insert a page break before a cell if the cell value meets
certain conditions.
I've tried the code below which seemd to work some of the time ut not
consistently.

Have a sheet (DATA) all info is entered here. Many userforms and modules.
Need to change some userforms and some modules. Two people are entering info
on (DATA) sheet. Have never done this before. How can I update thier copies
without affecting thier data entries? The sheet is in ...

I've been having trouble with this.  Other link inserts work but not this
one and I can't see why.
I have a main page with data starting in row 13.
I have individual sheets which are linked to the main page.  I'm inserting

I am trying to input symbolic numerical data that includes forward slashes ie
"5/5" in a simple excel spread sheet. However when I do so, it converts the
input into a date format ie: "5-may" or "5/5/07" Furthermore. Even if I erase
the content from the "evil" cell in question, ...

what's the VBA command to insert a row in a worksheet?
Worksheets().Rows().InsertRow ?
thanks

I'm trying to copy a large number of conditional formats from one set of
cells to another.  I don't want to explicitly define the formatting in VBA,
but rather take it from an existing set of cells.  Is there a way to do this
without parsing out all the various components of a ...

Column C contains string IDs with a varying number of blank cells between
each.
Having found the last entry in column E and the latest ID with:
     iDoorRow = Sheets("Pages").Cells(Rows.Count, 5).End(xlUp).Row

Hi, Kris here
I want to know how to determine wheather a cell in a worksheet has got
reference to other workshhet or reference in the same worksheet.
Thanks

I would like make a code to Jump from one Sheet (Sheet(client)For example)
to another Sheet (sheet(john)for example) only by clicking on specific
Cell on sheet(client), the text in cell(john) will be the name of the
already created sheet(john)& when sheet(john) become the active ...

Hi, I have text throughout a worksheet that look like this, for exampe:
%&%a1
I can run a macro to replace %&% with =, and that "turns on" the formulas.
However, I the formulas in question are much more complicated, and they need

Is there a way to tag/identify cells with the same value? When
creating cell values off of cells with the same value, I need a way to
distinguish that they are/are not values created from the same cell.
Ex. :

Can you please direct me to code that allows me to save my excel files in a
serially incrementing default name, such as book201, book203, book204, etc.
as you are aware, excel always go back to book1 whenever you start a new
cession, and it doesn't know that the last book was, ...

I have a column (column C) containing data with a custom format of h:ss. I
need to find the last 8:00 in the column and then insert a row below that
cell. I have looked in Walkenback's Books and the internet and unable to find
how to ge started with this. Any suggestions?

I've named few ranges through VBA by using this code
For i = 1 To 15
' Define the name for the variables
ActiveWorkbook.Names.Add Name:=Worksheets("ST&GT DATA").Cells(1, i),