I've got a sheet... defined print area... go to print preview and the
last column doesn't have gridlines... all the others do.  I want them
there, but I can't get them to show up... any ideas?
Using MSExcel 2002

hi guys, i may be chasing the impossible here, but here we go anyway. ive got
cells in my spreadsheet formatted so that they change colour depending on
what value is input. basically, i want to know if its possible for excel to
recognise how many cells of a certain colour i have ...

Can't believe I don't see how to do this.  I'd just like to protect a
workbook from being changed accidentally.  Don't want a password - I'm the
only OP.
Appreciate any suggestions.

I am very interested in learning more about using VBA in office, especially
Excel.  Can you post some resources (online, books, etc) that can be used to
help learn about using Visual Basic in office.
Thanks!

my cursor turns to a large white plus sign and when i move it it shades the
area blue and I'm not allowed to enter any data.

how can i do a vlookup with sum ?
e.g.
Given this table
a  1

how do I replace formula with value or cell code with value ?
excuse my terminology.
consider that just a subject title !!
I have 2 questions..

Folks,
The following codes looks through a selection and any time the macro
finds the value ("ticker") in the row, it selects that column and then
deletes it.

Is there anyway to have in the same cell 10% increase
ex; we shall input data $75.00 and this shall be changed automatcally to
$82.50 without having to have 2 cells or columns please explain

What is the best way to only protect cells with formulas in them?
Many thanks

Is there any add-ons which will enable me to measure the time needed
for work as Slimtimer?
Best.

I setup a vb that disables the save as on the file menu.
the code works as expected. But only if I click on run in the VB editor.
In general I have
sub

I can reproduce this error but can get rid of it.
I run my macros that places a number of lines etc onto a worksheet. If
I save this workbook as a .xlsm file then resopen it - everything is
fine.

I'd like to have text in a cell that is just informational. I would
not want it to print, or more importantly, if the file were saved as a
.csv file, I would not want it included in that delimited file.
I believe inserting a comment would work except that I would not want

hi, another question, ive got a list of people with their individual scores,
and now i want to order them into a list in descending order etc... how would
i do that? again any help greatly appreciated