might be long winded but it works
assuming that column A contains your data...
enter the 12 strings in cells B1 to B12
ensure cell C1 is empty
run this:
Sub checkstring()
For x = 35536 To 1 Step -1
Cells(1, 3).ClearContents
For y = 1 To 12
If Cells(x, 1).Value = Cells(y, 2).Value...
when creating tasks in ms project i assign a resource to the task.
is there a way of (at the time i assign a resource) flagging that the newly assigned resource has gone over 100%?
thanks
fax
is there a way to...
when i add a new task and assign a resource to that task i would like some sort of auto detection that alerts when the newly added task takes that resource above 100%.
if that makes sense then well done you.
thanks
fax
i'm in the midst of designing my website. i've made a shopping cart quick view.
i'm looking on advice on how useful it is.
if you hover over "view your cart" it should give you a brief of your card.
please take a look
any comments?
http://www.silverdiamonds.co.uk
thanks
fax
not usre if i'm out of my league here but...
it may be a cheaper option to use one pc, with one screen and use some VM ware to switch. you'll probably need to buy one massive hdd, and it'll take some knowledge and time to set up. but i think it's a neater and more reliable solution.
:)
fax
i know i can get hold of a sim copier. but they (to my knowledge) dont copy the sim password as well does anyone know of a sim copier that copies the numbers AND the password of the sim?
by sim i mean a normal gsm phone sim.
thanks
fax
i know i can get hold of a sim copier. but they (to mu knowledge dont copy the sim password as well) does anyone know of a sim copier that copies the numbers AND the password of the sim?
thanks
fax
from the subject this might look easy but it's not.
i'm trying to send an email in outlook 2002 to about 200 people from my address book. the catch is i want each recipiant to receive the email with only their name in the To: field.
I know i can use Bcc: but that way people know i've used...
from the subject this might look easy but it's not.
i'm trying to send an email to about 200 people from my address book. the catch is i want each recipiant to receive the email with only their name in the To: field.
I know i can use Bcc: but that way people know i've used Bcc, i want...
although, saying that. when i click end on the message and the form opens. it is working. it hides when there is no question and shows when there is a quiestion.
so thanks very much for that.
but how do i get rid of the error message?
cheers
fax
thanks again - i was using the name of the form rather than the form control. good tip.
however, now i get the following message:
"You entered an expression that has an invalid reference to the property Form/Report"
i tried both Ken and PH's
i wouldnt have thought referring to a siblisg (is...
Hi
I have a form called Project.
It has two subforms called Questions and Answers.
On the Answers subform I want to hide answerTextBox1 if questionBox1 (on the Questions subform) is blank.
any ideas?
cheers Fax
is there a way using outlook to:
- send an email to a number of staff members
- have a sign off area, so each person can sign off their part and their signoff will get sent to all other addressees.
- have a "Complete" field that is shown only when all areas are signed off.
i understand i might...
is there a way using outlook to:
- send an email to a number of staff members
- have a sign off area, so each person can sign off their part and their signoff will get sent to all other addressees.
- have a "Complete" field that is shown only when all areas are signed off.
i understand i might...
is there a way using outlook to:
- send an email to a number of staff members
- have a sign off area, so each person can sign off their part and their signoff will get sent to all other addressees.
- have a "Complete" field that is shown only when all areas are signed off.
i understand i might...
i have a customer database, where i can allocate booking sessions. however, i only want to be able to book no more than three customers per day. is there a way of automating it to that it will not allow users to beeok more than three customers per day?
cheers fax
in the table below i have a count of how many people (out of 6) can and cant attend on a certain day.
on the next row i would like to display the name of the person who cannot make it (but only if the count is 5)
ie, if only one person cant make it then i'd like to display his name.
ie, the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.