Search found 497 matches

by Mclaren
15 Feb 2012, 13:36
Forum: Hardware
Topic: Networking
Replies: 2
Views: 239

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 ...
by Mclaren
12 Jan 2012, 12:29
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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
by Mclaren
12 Jan 2012, 12:24
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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...
by Mclaren
12 Jan 2012, 12:22
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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...
by Mclaren
11 Jan 2012, 22:14
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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...
by Mclaren
11 Jan 2012, 06:24
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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.
by Mclaren
10 Jan 2012, 21:25
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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.
by Mclaren
10 Jan 2012, 19:33
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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.
by Mclaren
09 Jan 2012, 21:31
Forum: Applications Development
Topic: Excel, check if date is older then current month
Replies: 16
Views: 4047

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...
by Mclaren
08 Jan 2012, 09:24
Forum: Applications Development
Topic: Excel 2010 vba Intellisense not working, want to make text b
Replies: 8
Views: 3280

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 ?
by Mclaren
08 Jan 2012, 09:23
Forum: Applications Development
Topic: Excel 2010 vba Intellisense not working, want to make text b
Replies: 8
Views: 3280

Re: Excel 2010 vba Intellisense not working, want to make te

yes it was, thanks so much for the assistance.
by Mclaren
04 Jan 2012, 20:54
Forum: Applications Development
Topic: Excel 2010 vba Intellisense not working, want to make text b
Replies: 8
Views: 3280

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 ...
by Mclaren
13 Oct 2011, 08:41
Forum: Development & Design
Topic: EXCEL VB COPY CELL FORMULA
Replies: 0
Views: 1946

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...
by Mclaren
12 Oct 2011, 21:30
Forum: Development & Design
Topic: excel Problem
Replies: 3
Views: 2094

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.
by Mclaren
12 Oct 2011, 21:03
Forum: Development & Design
Topic: excel Problem
Replies: 3
Views: 2094

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+...
by Mclaren
25 Aug 2011, 10:34
Forum: Software
Topic: 2D animation
Replies: 3
Views: 519

Re: 2D animation

thanks guys. will check it out
by Mclaren
24 Aug 2011, 22:00
Forum: Software
Topic: 2D animation
Replies: 3
Views: 519

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 ?
by Mclaren
14 Aug 2011, 19:28
Forum: General Chat
Topic: I Want to sing Gospel
Replies: 1
Views: 367

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.
by Mclaren
31 Jul 2011, 10:55
Forum: The Magazine
Topic: no longer buying the mag
Replies: 74
Views: 13072

Re: no longer buying the mag

This months zine is much better.

I really like the article of virtualisation.
by Mclaren
06 Jul 2011, 15:07
Forum: The Magazine
Topic: no longer buying the mag
Replies: 74
Views: 13072

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....
by Mclaren
06 Jul 2011, 14:10
Forum: The Magazine
Topic: no longer buying the mag
Replies: 74
Views: 13072

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...
by Mclaren
05 Jul 2011, 16:18
Forum: The Magazine
Topic: no longer buying the mag
Replies: 74
Views: 13072

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...
by Mclaren
05 Jul 2011, 16:07
Forum: The Magazine
Topic: no longer buying the mag
Replies: 74
Views: 13072

Re: no longer buying the mag

Stuart wrote:
Mclaren wrote:you could do, but its still so nice to read something printed rather than my computer screen.
You could always use the G3AR printer recommendation to print out your required article for reading.

ha ha ha ha ha....oh the lighter side.....thanks Stu....i needed a good laugh
by Mclaren
05 Jul 2011, 16:05
Forum: The Magazine
Topic: no longer buying the mag
Replies: 74
Views: 13072

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...