I have a sample bit of code:
           If Cells(iRow + 11, 1).Value < date_L119 Then
                 .Cells(iRow + 11, 22).Value = "NP"
           End If

Is there any way to store the format of a certain cell into a variable?  For
example:
frmt = Range("A1").format
... Then I could do something like:

I'm new to VBA programming and am attempting to add a 4th conditional format
by editing a recorded macro and am receiving this error message.
Here is my code:
Sub Conditional_Formatting()

I am using Excel 2003. I set up control buttons on a worksheet to sort
selected areas of the sheet in certain predefined manners.
I would like to reset the captions of all the buttons when the
workbook is opened. However, it appears that there's no way to

Dont have access to "Access", but could use Excel as a Database. Does
anyone have any sample code they could share, of quering a database
for a entry, or updating a excel database with a record.
Trying to upgrade from shared spreadsheets.

Duuuuudes:
I'm not sure really what to ask here, but I am having a sporadic issue with
conditional formatting on a pivot table. I have the code below that is
applying 3 conditional formats to a pivot table's data. Before these

Hello all- I know that we spoke before about removing a trailing comma, so i
tried to amend that code to remove a leading comma from a range, but it's not
working in cells where there's anything after the comma. Could anyone point
out what I did wrong with this code?

I am trying to write a macro which will hide columns that do not have a "1"
in row 2.  This is the code I am using, but there is something wrong with it.
Is anyone able to help?
   Dim rng As range

I need help with creating a function within excel worksheet. Which
will look for a keyword "Summary" and if it will find it then I would
like to highlight the entire row with green color.
Thank you

Hi,
I'm looking to create a vlookup that will extract data from within a cell
that matches with something found in a range.  
input cell                 range      results cell

Will hideing columns affect the way code runs. Or will vba still know the
column is in place. Have code not sure how to change it but relize if I make
worksheets have same nbr columns it will work.
Thanks

I use the following code to copy the worksheet selected in a listbox, to a
new workbook.  Problem, this code copies a button on this worksheet, and i
don't want it to be copied.  Can I prevent this?
the button on the sheet is called 'cmdMainMenu'

I want to copy and paste the following cells:
Copy cells A1:x5 from the Work Schedule tab and paste to cells A1:X5 on the
Overtime tab
Copy cells D6:D35 from the Work Schedule tab and paste to the cells D15:X44

I am trying to use this code to make sure a value doesn't exist in the
Copreco Master Log.  I get an error that says 'variable not defined' and it
highlights ' the "mydate" row.
I am not sure what is wrong...any ideas?

I have a very large WB containing over 200 WS, broken basically into 4 sets
of 50. When I try to populate a couple of columns in one of these sets using
a macro to copy the data from its companion WS in another set, it runs out of
steam with this message ""Excel cannot complete ...