Posts by joshua_leak

Re: VBA Change output in the bottom right 2003

That's a shame.

Thanks anyway.

Hi,

I've searched around abit but seeing as I don't know what the view in the bottom right is really called, I can't find any help. Also the maco recorded didn't help.

In 2003 there is a section in the bottom right of the screen where it shows you if caps lock is on and shows you the sum of the selected cells.

You can change the output of this calculation by right clicking on it then selecting the desired function.

What I would like to do is change the function it shows using VBA.

The macro recorder doesn't register anything if I change the output whilst it is recording.

If anybody know's how to reference to that output that would be great thanks.

Josh

Re: VBA FOR NEXT problem

Good spot

Re: VBA FOR NEXT problem

What a simple solution, can't believe i didn't think of that.

Thank you

Hi there,

I have the following code which is giving me the error "Next without For":

[vba]
Dim IndividualCell As Range
Dim Cellformula as String

For Each IndividualCell In Selection
CellFormula = IndividualCell.Formula
If InStr(CellFormula, "=SUM(IF(") = 0 Then Next IndividualCell

'Process here

Next IndividualCell[/vba]

I can understand why the error is coming up but i don't know what the correct code is.

Could anybody help?

Thanks

Re: Vlookup with several matches

Thanks for the solutions and explantions, they helped a lot!

Re: Combine two Formulas based on different conditions

Not quite sure what you're after here.
You are missing one value_if_false so I put your original formula in there.

=IF(C8="Thursday",1,IF(C8="Absent",0,IF(C8="Holiday",8.5,(D5-C5+(D5<C5))*24)))

If this is wrong please try to explain in more detail what you are after

Re: Vlookup with several matches

Thanks for that, I appreciate the help

Hi there,

I need to do a lookup which "may" have to return several results.

I've found plenty of sites giving formulas to give the n^th return. The only problem with these is that they assume there will always be multiple matches.

I have attached a file with an example of my problem. [ATTACH=CONFIG]40878[/ATTACH]

There is a data tab with people's weight, the point of which is to measure weight loss. I have a front sheet which auto-sorts the data using the "SMALL" formula to sort the data, and Index/Match to bring the name in.

The problem i have is when there is multple people with the same percentage weight loss, on the result tab, it show the value several times but shows the same name on each occurance.

Re: 2003 Customise Autoformat

Ok then. Thanks

Hi there,

I like the idea of the feature "Autoformat" in 2003, but the color schemes on there don't match my requirements.

Does anyone know a way to customise these?

Thanks,

Re: Me.Enabled = True Not Working on UserForm

If screen updating is turned off in the macro, I would assume that they wouldn't be able to interact with the userform anyway?

Re: Me.Enabled = True Not Working on UserForm

Could you not just turn Application.ScreenUpdating = False in the macro then they won't be able to do anything anyway?

Re: Getting A String Of Hash Sign Because Character Length In A Cell Is Too Large

Thanks for the answer but, I don't think that it was worth bringing back a 4 year old post.

Re: VBA Loop to print to PDF

That in theory would work, only problem is naming it in the first place with the promt?

Re: VBA Loop to print to PDF

We have PDF printers (which do the conversion) installed, but when you use it, it prompts you for a name to save the file as and doesn't easily allow you to change file path

Re: VBA Loop to print to PDF

Unfortunately not, I'm trying to do it at work and i can't see them upgrading any time soon

Re: VBA Loop to print to PDF

2003

Hi there,

I've done a few searches but nothing works exactly how i would like it to.

I'm creating a statements in a loop using excel then emailing it to them.

What I would like to do is also save it as a PDF but when I print to the PDFprinter, it prompts for a file name.

I would like to skip this by specifying a file path and just using the person's name as the filename.

Does anybody know how I can accomplish this?

Thanks

Re: average cells with missing data (VBA)

Ah yes, good spot.

Only problem with that is it doesn't correctly pick up all the figures. See attached for an example

[ATTACH=CONFIG]40111[/ATTACH]