Is it just my eyes, computer or has the site suddenly changed in appearance?
Posts by Badger101
-
-
Re: Delete Macros
does this link to chip's site help you at all?
-
Re: Use Of Udf In Vba
You could also set a reference to your personal.xls vbaproject in the other workbook by going tools-references and placing a tick next to the vba project name.
-
Re: Sumproduct Till Last Used Cell
See dynamic named ranges
-
Re: changing Office Assistant
I have only bothered to look at programmming the assistant once in a post on this thread.
http://www.ozgrid.com/forum/showthread.php?t=61331
have a look at it.
-
-
Re: Count Of Records With Filter
Just for more info here is the basis of the formula used for the solution by Laurent Longre.
-
Re: Count With Filter
Sorry should have answer this for you in yesterdays example.
Try.
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B7:B33,ROW(B7:B33)-MIN(ROW(B7:B33)),,1)), --(B7:B33>500))
Edit: Just seen Kris most have found the solution just before me.
-
Re: Only Simply Vba Key Trapping
Think Roy will give you the same response as he did last time. Problem is you are trying to capture key strokes in an application other than Excel by using VBA within Excel. I pretty certain you will not be able to that.
-
Re: Finding The Errors
Yep sure is. Need to up my first quote to 7.
-
Re: Finding The Errors
Quick glance says 5 errors. Is it homework or something?
-
Re: Count Of Records With Filter
=subtotal(3,$c$7:$c$33)
-
Re: Sorry
Roy - please allow un referenced cross posting so we can spend hours coming up with solutions which have been done by somebody else in a different forum. NOT.
LOL
-
Re: Macro Recording 2007
Got to say that the office 12 product on the whole is very impressive.
-
Re: Display Pdf In A Userform
So you can not find the control if you right click the toolbox and select additional controls?
-
Re: Display Pdf In A Userform
Have you put the control on the userform?
If so, can you see a reference to the control in the intellisense after you type me. ?
-
-
Re: Text Formula? Postcodes
No doubt there.
-
Re: Text Formula? Postcodes
Welcome to Ozgrid.
In b3
=LEFT(A3,IF(LEN(A3)=3,2,1))
-
Re: Assign Multiple Variables
You would need to do
Your way has x and y as variants. Vba works a bit differently in that respect. Also you can not intialise the variable when it is declared like you can with other languages.
Nearest you will get to one line is