how to use vba in excel
Mon, 18 Aug 2008 12:56:16 -0700
I would like to work with an example sample to enter vba int excel ...
|
Fill color by date
Mon, 18 Aug 2008 11:49:05 -0700
I'm working with Exel 2007. I made a simple spreadsheet with several due
dates of a particular project. The spreadsheet shows when a person first came
onto the company, and I need to track when their evaluations are due. The
first is due 30 days after, 10 months after and a year after the initial hire
date. ...
|
Right Alignment
Mon, 18 Aug 2008 11:33:01 -0700
Is there a straight forward way for one to right align a print-out?
--
Paul Gauci ...
|
how do you take an answer in a cell and converting it from grams .
Mon, 18 Aug 2008 08:58:20 -0700
I have a spread sheet set up for some test I run for my job. I'm kinda'
teaching myself as i go, how to use all that Excel can offer. right now I
have the spred sheet set up so it will give me the difference between two
cells and present the answer in a different cell, which is great. Now I
wanna' take th ...
|
formular
Mon, 18 Aug 2008 08:13:01 -0700
if 30<a1<40 after that write in a2 ,"no".what is formular ...
|
percentages
Sun, 17 Aug 2008 16:17:00 -0700
I have a chart of prices. I want to make another chart which will show a
percentage of the prices in the first chart. eg. 20% of all the prices.
I have no idea how to start
Please help
Thanks ...
|
calculate 18 monts from a date
Sun, 17 Aug 2008 09:59:00 -0700
Hi I need to calculate from une date if 18 monts has past, if is false put a
"X" on if is true livet in blank (no 0 )
ex
Kevin start on 06 mai 2007 still no 18 monts = "X"
Tony start on 03 fev 2007 hi pas 18 monts = " "
tanks ...
|
|
|
Cell protection ?
Sun, 17 Aug 2008 16:58:18 +0100
Hi,
When a formula is entered into a cell is there a way to protect that
cell so the formula cannot be removed?
Appreciate your assistance ...
|
Re: Drop Down List
Sun, 17 Aug 2008 07:09:41 -0700 (PDT)
On 5 Aug, 17:46, Pete <fell-wal...@hotmail.co.uk> wrote:
> On 1 Aug, 22:59, Gord Dibben <gorddibbATshawDOTca> wrote:
>
>
>
>
>
> > I think this is it.
>
> > Tested on both the DV drowdown selection and the multiply by Offset(6, 0)
> > codition.
>
> > Private Sub Worksheet_Change(ByVal Target As Range)
> ...
|
Password for rows and columns
Sun, 17 Aug 2008 06:56:00 -0700
Is there a way to hide a row & column with a password in a worksheet, in such
a way that the other user should be able to work on the same worksheet but
with the remaining rows & columns, without being able to open the hidden row
& column ...
|
