I've written a large pricing application in Excel. Lots of VBA and User
Forms, but very concisely written. I need to add a feature written by
someone else. This other programmer is not known for concise code. My
question here is why has he used Class Modules instead of simply having ...

This is a follow up from my previous mail, is it possible to check if a
picture is present on a particular cell i.e. check if graphic1 exist on Cell
A1 and also check its size?
Thanks!

I have a range on sheet1 ("A12:A19"). I need to be able to look at that list
and if any name from that list is found on sheet2 ("J3:J400") then delete the
entire row that it is found in.
Thanks!

I want to hide the contents of a cell.
Not protect the cell, simply hide the contents.
Something like:-
Range("A1").Contents.Hidden=True

I have a worksheet that has a header column.  Underneath it has two info
columns.  There is a column between Hours and the date, there is another
column between names.  I copy this sheet from another sheet which has
everyone's name then delete certain names based on office.  I ...

i need to create a cell that will blink a chosen colour if a condition is
true as in (conditional format)
thanking you all
sayen

Is there a way to change the color of a couple of lines of code.  Each year I
have to search through a lot of code to modify specific lines.  I was
wondering if there is a way to change s line or two of code to a different
color (say red), so next year I can scroll through the ...

I am creating an excel template of which the first sheet has lots of
rows. Each row represents a record with data in it ( text, numers and
a small picture)
On the other sheets I refer to cells on the first sheet. I do that

I have a listbox that the user can make any number of selections
(multiSelect)then click the cmdSelect button and have it fill another form
with labels from the selections. The following code uses the selections but
on the form i have to have say 10 labels already set up to be ...

I am using the following code to delete rows if the values in column Z = 0
Dim Firstrow As Long
Dim Lastrow As Long
Dim Lrow As Long

Is it possible to program a cell in Excel to convert lowercase letters
to capital letters? Ex.: I type 'e' in a cell and upon pressing enter
it changes to 'E'. If I type 'E' in the cell nothing should happen. If
I type 'Ee' it should change to 'EE'.

I am looking for a macro to save an updated file (created from an older one
using a macro) in the same directory as the original. The newer file will
then transfer some of the data from the older file to the newer.
When I run the macro I created on my own PC from the directory ...

Hi all, I have a spread sheet that i am copying the entire line if
column 4 has the letters "lc" in, it works great as long as the letter
case is lower. If a user puts the case, in the system that the
spreadsheet gets it's information from, in upper case then my code will

OK, I'm getting a little desperate here.  My real problem is with windows xp,
but i can't seem to get any of the links to workso i can ask this same
question in their discussion forum...i get "error on page" at the bottom of
my screen and the page doesn't load or change at all.  ...

Hellos,
I have worksheet which contains data almost 35 000 rows. To facilitate easy
reading I want to make alternating color rows. But his will affect vefry
solow in performance.