Search found 497 matches
- 15 Feb 2012, 13:36
- Forum: Hardware
- Topic: Networking
- Replies: 2
- Views: 241
Networking
I have my home network setup, currently i have a Neotel wireless router with: 4 devices running wired: Xbox, and 3 computers 6 wireless items: ipod,3 phones and 2 notebooks I need to add a few more wired: namely a printer and a TV. Can i use a switch in there somewhere and if so how, where do i put ...
- 12 Jan 2012, 12:29
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Re: Excel, check if date is older then current month
Don't answerjust yet, going to go research the function first.
If i still don't come right, i will let you know
If i still don't come right, i will let you know
- 12 Jan 2012, 12:24
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Re: Excel, check if date is older then current month
Is there a reason why there is a date after the DateSerial ? DateDiff("m",now,DateSerial( 2011,12,7 ))== -1|Expired DateDiff("m",now,DateSerial( 2012,01,23 ))== 0 | Current DateDiff("m",now,DateSerial( 2012,02,19 ))== 1 | Future DateDiff("m",now,DateSerial( 20...
- 12 Jan 2012, 12:22
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Re: Excel, check if date is older then current month
Thanks Rustypup: This is my current formula: ActiveCell.Formula = "=IF(AND(YEAR(G2)=YEAR(NOW()),MONTH(G2)=MONTH(NOW())),""EXP - UPLIFT"",IF(AND(YEAR($G2)>=YEAR(NOW()),MONTH($G2)>MONTH(NOW())),IF(AND(YEAR($G2)>=YEAR(NOW()),MONTH($G2)>MONTH(NOW())+1),IF(AND(YEAR($G2)>=YEAR(NOW...
- 11 Jan 2012, 22:14
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Re: Excel, check if date is older then current month
Thanks Rustypup, Afet spending 3 hours last night tweaking the oringal formula. It still does not work properly, I will post my formula tomorrow, with an example of the errors. After reading my original post, I noticed i did not state my requirements correctly. My Aim is to: determine if a cell valu...
- 11 Jan 2012, 06:24
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Re: Excel, check if date is older then current month
I receive a spreadsheet that needs to be formatted every Dayan the same way. I used to check the values manually, So I have made a macro to do all of it in one go. This includes inserting formulas.
- 10 Jan 2012, 21:25
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Re: Excel, check if date is older then current month
Vocab, English Language, thinking before typing....comes difficult to me....LOL
Anyways, I needed it for VB that why i said what i said, and a few tweaks and yes i got it working. what a mission.
Anyways, I needed it for VB that why i said what i said, and a few tweaks and yes i got it working. what a mission.
- 10 Jan 2012, 19:33
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Re: Excel, check if date is older then current month
Extend....Cough...Splutter...Cough....Cough.....
When it comes to excel VB i am clueless.
Tahnks guys gonna test the code now.
When it comes to excel VB i am clueless.
Tahnks guys gonna test the code now.
- 09 Jan 2012, 21:31
- Forum: Applications Development
- Topic: Excel, check if date is older then current month
- Replies: 16
- Views: 4172
Excel, check if date is older then current month
I am trying to eliminate repetetive formating of worksheets and have come accross a problem where i need to determine when a product expires: I have found many example of wether a date is older than today, but i need to fin out if cell is older than current month. if cell A1 has date : 2011/12/31, b...
- 09 Jan 2012, 21:26
- Forum: Applications Development
- Topic: Excel 2010 vba Intellisense not working, want to make text b
- Replies: 8
- Views: 3384
Re: Excel 2010 vba Intellisense not working, want to make te
Thanks tribble
- 08 Jan 2012, 09:24
- Forum: Applications Development
- Topic: Excel 2010 vba Intellisense not working, want to make text b
- Replies: 8
- Views: 3384
Re: Excel 2010 vba Intellisense not working, want to make te
can the horizontal and vertical postions be located in relation to a specfic cell ?
- 08 Jan 2012, 09:23
- Forum: Applications Development
- Topic: Excel 2010 vba Intellisense not working, want to make text b
- Replies: 8
- Views: 3384
Re: Excel 2010 vba Intellisense not working, want to make te
yes it was, thanks so much for the assistance.
- 04 Jan 2012, 20:54
- Forum: Applications Development
- Topic: Excel 2010 vba Intellisense not working, want to make text b
- Replies: 8
- Views: 3384
Excel 2010 vba Intellisense not working, want to make text b
So as my title says, Excel 2010 vba Intellisense is not working, and i want to insert a text box using code. My problem is, i have no idea how to do this. I have successfully recorded a macro, but the code means nothing to me. In Access my intellisense works, but bot in excel. with intellisense one ...
- 13 Oct 2011, 08:41
- Forum: Development & Design
- Topic: EXCEL VB COPY CELL FORMULA
- Replies: 0
- Views: 2040
EXCEL VB COPY CELL FORMULA
I am trying to copy a formula from on cell to a selcted range. i get an error message though. Runtime error 1004 Autofill method of Range class failed my code : Selection.AutoFill Destination:=Range("L2:L" & intMyCount), Type:=xlFillDefault Range("L2:L" & intMyCount).Sele...
- 12 Oct 2011, 21:30
- Forum: Development & Design
- Topic: excel Problem
- Replies: 3
- Views: 2200
Re: excel Problem
Got it, I had a circular reference.
line :
Cells(intMyCount + 1, 6).Formula = "=sum(f2:f" & intMyCount + 1 & ")"
should read:
Cells(intMyCount + 1, 6).Formula = "=sum(f2:f" & intMyCount & ")"
Thanks.
line :
Cells(intMyCount + 1, 6).Formula = "=sum(f2:f" & intMyCount + 1 & ")"
should read:
Cells(intMyCount + 1, 6).Formula = "=sum(f2:f" & intMyCount & ")"
Thanks.
- 12 Oct 2011, 21:03
- Forum: Development & Design
- Topic: excel Problem
- Replies: 3
- Views: 2200
excel Problem
I am pretty new to Excel VB. I have a spread sheet which i Filter for certain records, count the records and sums column F. all works well except the summing. all i get is a zero my code is : Sub Cons_Sheet_Format() ' ' Cons_Sheet_Format Macro ' Format the Cons Worksheet ' ' Keyboard Shortcut: Ctrl+...
- 25 Aug 2011, 10:34
- Forum: Software
- Topic: 2D animation
- Replies: 3
- Views: 522
Re: 2D animation
thanks guys. will check it out
- 24 Aug 2011, 22:00
- Forum: Software
- Topic: 2D animation
- Replies: 3
- Views: 522
2D animation
My kid has a project where she has to make a animated movie from images. we have about 2000 images, but i need some form of software that can put all these together into a movie file.
I checked google, but am totally confused about what to use. any ideas ?
I checked google, but am totally confused about what to use. any ideas ?
- 14 Aug 2011, 19:28
- Forum: General Chat
- Topic: I Want to sing Gospel
- Replies: 1
- Views: 370
I Want to sing Gospel
Hey all. My Brother in LAW is singing on "I want to Sing Gospel" Watch it tonite on SABC 2 at 8pm.
Vote for Malcolm by sms to 34709 and SMS the word MALCOLM
Also check out his like page on FB: Malcolm Manuel - I Want to Sing Gospel.
Vote for Malcolm by sms to 34709 and SMS the word MALCOLM
Also check out his like page on FB: Malcolm Manuel - I Want to Sing Gospel.
- 31 Jul 2011, 10:55
- Forum: The Magazine
- Topic: no longer buying the mag
- Replies: 74
- Views: 13344
Re: no longer buying the mag
This months zine is much better.
I really like the article of virtualisation.
I really like the article of virtualisation.
- 06 Jul 2011, 15:07
- Forum: The Magazine
- Topic: no longer buying the mag
- Replies: 74
- Views: 13344
Re: no longer buying the mag
awe come on....thats not really an answer, i don't really worry about how many are sold, just how the count is performed.
Its like a CD, an artist may go platinum cause his album sales are 4 trillion, but maybe those cds are all sitting in a shop somewhere....
Its like a CD, an artist may go platinum cause his album sales are 4 trillion, but maybe those cds are all sitting in a shop somewhere....
- 06 Jul 2011, 14:10
- Forum: The Magazine
- Topic: no longer buying the mag
- Replies: 74
- Views: 13344
Re: no longer buying the mag
While Michael wasn't far off in saying our readership isn't shrinking how are the numbers calculated ? do you: count how mags are actually purchased from stores or count how many mags are supplied to stores (when there are surplus at the stores at month end, are those included in the sales or actua...
- 05 Jul 2011, 16:18
- Forum: The Magazine
- Topic: no longer buying the mag
- Replies: 74
- Views: 13344
Re: no longer buying the mag
well if you noticed the reviews icons at the top. If you click the PC one you will get PC hardware and game reviews. Tech is for all your non PC gadets etc. I will be doing lots of reviews on the site. This site is not just a side show for us. We plan to clone ourselves and spend 12 hours a day wor...
- 05 Jul 2011, 16:07
- Forum: The Magazine
- Topic: no longer buying the mag
- Replies: 74
- Views: 13344
Re: no longer buying the mag
Stuart wrote:You could always use the G3AR printer recommendation to print out your required article for reading.Mclaren wrote:you could do, but its still so nice to read something printed rather than my computer screen.
ha ha ha ha ha....oh the lighter side.....thanks Stu....i needed a good laugh
- 05 Jul 2011, 16:05
- Forum: The Magazine
- Topic: no longer buying the mag
- Replies: 74
- Views: 13344
Re: no longer buying the mag
I watch click on Saturday mornings (BBC news), now thats what i would like to see in the magazine, the show has a way of discussing so many different topics about PCs and their high tech cousins eg smartphones tablets etc, that it has me glued, almost like a sopie where i cannot wait for the next ep...