I have written the macro (my first!) as below
Function FindOldNominal(NomCode)
FindOldNominal = WorksheetFunction.VLookup(NomCode, range("IMPORTRANGE"), 5,
false)

Good afternoon,
Is there anyway that I can use the CountIF function in a macro that
would allow me to determine the number of "No" values in a row.
This is what I have so far, but it does not work this way... any

I am trying to use the following code to capture a couple of dates from
cells.
       dStart = Application.WorksheetFunction.VLookup(c.Offset(0,
-COff).Value, _

If I have a cell A1 with the formula:
=DATE(1900, 4, 15)   ==> Easter Sunday in 1900
and then I try to calculate Ash Wednesday for 1900 in cell B1, which is
46 days before Easter:

Is there an easy way to copy all UserForms & modules from one workbook
to another? I can drag each one, but for future reference, I'd like to
make it easier.
Thanks,

This is just a  little peculiarity that I've not seen before - it's
probably a system thing rather than a VBA thing.
When I open the VBA editor in the morning after logging on and opening
Excel the Immediate window is full of the following wierdness:

I am trying to include an MSFlexgrid component into Excel to be used in
macros. Once adding the MSFlexgrid component into a 'Form' i get the
message similar to "The Control can not be created due to faulty
license"

I am new in using macros and I ve a column of datas numbers and I would
like to do the following :
for exemple 1.85 go to 2, 1.15 go to 1, 4.45 go to 4 etc
waiting for your help buddies

Hello from Steved
How would I modify please the below to copy an entire row Thankyou.
Sub Broken()
Selection.EntireRow.Insert

I currently have the pleasure of having to get up to speed with some
undocumented spreadsheets. To aid me, I'd like to visually identify all
formulas within these spreadsheets. I have been able to do this manually
successfully using "Conditional Formatting..." and a user defined

My current workaround to this problem is to declare the function as
Public Function xyz(abc as Range) as Variant
'Code
'klm is an array

Hi TWIMC
I wanted to check to ensure a picture logo is present on a worksheet before
I moveit.
So something like

I am trying create a VB function that will take two ranges of cells as inputs
(both in columns) from Excel, convert them to arrays, perform necessary
calculations on them within a third array, and output the computed array as a
range of cells (in column form) back to Excel.  As ...

Excel 2003.  I have a user form called "ProcessStatus" that has a text box
called "ProcStat" which is populated with information as a process completes.
I have placed a "Print" button control on the form that I want to use to
print the contents of the text box.  What code would ...

I am trying to use a spreadsheet that I made in Excel2003, on a machine
running Excel97.  Specifically I am getting an error in Excel97 when invoking
the protect/unprotect methods of the ActiveSheet.
When I step through the code in the VB editor - it works fine; however, when