Call in the Cavalry - 2013

[FDibbins]

can any1 help with the mess this poor OP has?

http://www.excelforum.com/excel-form...hing-rows.html

[FDibbins]

i really gotta start learning VBA. can anyone help with this?
http://www.excelforum.com/excel-form...ther-cell.html

[abousetta]

Wonder if anyone has any handy code that searches non-Excel files without opening them for a string (http://www.excelforum.com/excel-prog...78#post3064278). snb has posted alternatives for FileSearch, but this still requires opening/ closing the files to read their contents.

[FDibbins]

I saw a similar question answered a little while back, but my searches havnt found it on the forum...

http://www.excelforum.com/excel-gene...el-2003-a.html

[Andrew-R]

You're right, I remember that thread (I may have posted some VB code to do the job), but there was an answer that involved some hang-over from the days of Excel 4 macros.

Unfortunately, I can't find it either. Sorry

[daddylonglegs]

but there was an answer that involved some hang-over from the days of Excel 4 macros.

Try googling GET.CELL(48

I posted a link in that question

[Andrew-R]

Thanks, DLL.

I taught myself macros in Excel 4 when I first started getting into Excel, but (oh god) that was nearly 20 years ago now, and I've managed to forget everything I ever knew

All I actually remember about the 'old' religion is:

1. It took me ages to work out from skimming the manuals that you had to use named ranges to initialise variable, and

2. There were some neat ways of doing common things, like working out the last used row on a sheet, that VBA didn't do so well (although I forget what the neat ways were)

[jeffreybrown]

Ok I give up. Anybody have a smart VBA routine to solve this matrix.

http://www.excelforum.com/excel-gene...g-entries.html

I went with a worksheet change event to fill in both cells with the same value, but being the table is 25 X 25 this would require many IF constructs.

[JBeaucaire]

This OP in this thread is looking for some advice (see posts #4 and 5) on dealing with 20k rows of "semi-duplicate" name/address strings.

[dredwolf]

Anyone with some "HYPERLINK" formula knowledge, I think I dove FAR too deep on this one: http://www.excelforum.com/excel-formulas-and-functions/889302-return-hyperlink-that-already-exist-in-sheet-if-statement-is-true.html?p=3073713#post3073713
Any help VERY welcome !

[alansidman]

I have no idea how to take this one to the next step. Need someone with MAC, Excel and Outlook experience to help this OP.

http://www.excelforum.com/excel-gene...read-only.html

Alan

[jeffreybrown]

Anybody have a solution to conditional format a cell with VBA based on the time the value was entered?

Was thinking this would work in the intermediate window, ?Format(time,".00"), as this produced .86

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1:A5")) Is Nothing Then
        Application.EnableEvents = False
        Select Case Time
        Case Format(Time, ".00") > 0.83 Or Format(Time, ".00") < 0.88
            Target.Interior.ColorIndex = 3
        End Select
        Application.EnableEvents = True
    End If
End Sub

http://www.excelforum.com/excel-form...with-time.html

[Norie]

Jeff

Couldn't you use Hour?

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1:A5")) Is Nothing Then
        Select Case Hour(Time)
            Case 1            
                Target.Interior.ColorIndex = 3
            Case 2    
                Target.Interior.ColorIndex = 4
            Case 3
                Target.Interior.ColorIndex = 5
            ' other 21 cases that it's too late to write out
        End Select
    End If
End Sub

[dredwolf]

If anyone can help here:http://www.excelforum.com/excel-form...30#post3076730

it would be GREATLY appreciated

[mike7952]

Hello Calvary,

Can someone help me see the light
@ http://www.excelforum.com/showthread...=1#post3078057

Im not seeing how these are to be grouped.

Edit also OP gives example of how they need to be grouped in Post#3

[JBeaucaire]

Those interested in Cavalry calls should consider subscribing to the new thread located here:
http://www.excelforum.com/the-water-...5-onwards.html

[Marcol]

I'm not able to simulate the OPs' problem here
http://www.excelforum.com/excel-form...in-a-cell.html
Posts #15/16 explain the problem, could someone with 2007, or later please have a look. The OP is using 2011.

Thanks.

[rgrov004]

This is an excel problem that started out as a good thread but never came to a conclusion from a few weeks back.

http://www.excelforum.com/excel-form...html?p=3052752

[FDibbins]

rgrov004 this is not the place to "bump" a thread that hasnt been responded to. you need to type something (like bump) into the thread to bring it back to the top of the list again

[dredwolf]

I think the solution for this one http://www.excelforum.com/excel-form...73#post3085173 is going to require more VBA skills than I currently have..

[tahoeast]

Cavalry? I posted the following that I thought was do-able http://www.excelforum.com/excel-form...golf-team.html But maybe it wasn't as easy as I thought, or maybe I'm not being clear enough in my question.

Maybe I'm just new to the whole thread thing and I'm violating some rule I don't know about. Any help is greatly appreciated.

[martindwilson]

@ tahoeast this is a subforum for members to call for assistance with a problem ..not to bump yours!
having said that...anyone have ideas here
http://www.excelforum.com/excel-form...golf-team.html

[FDibbins]

can any-one offer any suggestions to this OP?
http://www.excelforum.com/excel-gene...95#post3084995

File size growing and cant figure out why

[:) Sixthsense :)]

Someone please look in this thread and relieve me from this one

http://www.excelforum.com/excel-form...are-met-2.html

[:) Sixthsense :)]

One more help required with this thread also....

http://www.excelforum.com/excel-prog...ng-a-list.html

I believe OP needs something like this to find the relevant row.....

x = Application.Match(Me.txtStep.Value, .Range("A:A"), 1)

For i = 1 To .Cells(Rows.Count, "A:A").End(xlUp).Row
    If .Cells(i, "A").Value = x Then
        x = i
        Exit For
    End If
Next i

[jeffreybrown]

Anybody have some ideas about what would work here?

http://www.excelforum.com/excel-form...f-formula.html

[FDibbins]

I thought I had this, but it seems not....
http://www.excelforum.com/excel-gene...html?p=3087099

[FDibbins]

ok, heres a kinda weird 1???

http://www.excelforum.com/excel-gene...81#post3087281

[RHCPgergo]

Can anyone shed some light on this problem?
http://www.excelforum.com/excel-prog...too-large.html

[arlu1201]

Can someone please assist this user - http://www.excelforum.com/excel-prog...-in-cell.html?

[Marcol]

This guy is having problems down loading the attachment in post #11 here Counting number of records in a given date range.

Seems to be getting #NAME! errors, but I can't see why, both post#11 and #20 download okay at my end ...

Could someome try opening them and see if they get the errors, or shed some light on why they might be occurring?

Thanks.

[Kyle123]

Anyone fancy having a look here: http://www.excelforum.com/excel-prog...35#post3096535

The code works fine on my computer and I can't really see why it wouldn't work on a mac, but it doesn't.

[jeffreybrown]

Seems to be a little out of my comfort zone...

http://www.excelforum.com/excel-form...time-card.html

[kcarley]

[QUOTE=jeffreybrown;3096555]Seems to be a little out of my comfort zone...

Hi there Jeff,

I'm really new here but I understand completely what the OP needs. What I am not sure about is that the forum rules are being followed. This is a straight forward calc, I'd probably do it in VBA just because that's what I like best but it would take some effort; wouldn't it be logical to help the OP fix what he's done so far? If he did anything to try to complete this it is not in his worksheet or post. I'm looking to you for moderation on this as I am new. I'm always happy to help but this is the sort of thing I get paid to do; it just wouldn't seem fair if the OP gets paid for what I do too...

Regards,
K

Never-mind! I re-read the OP and I think I may have been able to help, we'll see. Always room for others to see something I may not have. Laterz.

[Moo the Dog]

I'm always happy to help but this is the sort of thing I get paid to do; it just wouldn't seem fair if the OP gets paid for what I do too...

Ahhh, the great conundrum. Actually, it's not that difficult to figure out... if those of us who have VOLUNTEERED hours and hours of our own time to help others decided not to do so, the site would have little to no value, and would likely cease to exist.

Personally, I choose to help however I can knowing that:
1. I won't receive a single cent for the advice I share
2. Sometimes I won't even receive the courtesy of a 'Thank You' from the OP

I just enjoy helping other people solve their Excel problems. My real job pays the bills. But the decision is indeed an individual one. Choose wisely.

- Moo

[TMS]

I agree totally with everything that Moo has said. If it troubles your conscience, or your pocket, forget about it.

Regards, TMS

[jaslake]

@Moo

Hear, Hear!!!!

[jeffreybrown]

I'm thinking a macro for this problem here...

Any takers?

http://www.excelforum.com/excel-char...n-one-row.html

[abousetta]

Anyone good with ODBC? Trying to use ThisWorkbook.Path in this thread but not working for the OP. He thinks it might be a Windows permission issue but I don't have enough background knowledge to confirm or refute this theory.

Thanks.

abousetta

[arlu1201]

Need a lil help here - http://www.excelforum.com/excel-prog...pc-cell-3.html.

The code in post 33 works uptil the Save as part. I am not sure how to loop each workbook to be emailed. I have never worked on that part of it.

So first the macro will create each file and save them in a folder. Then each one needs to be emailed out. The first part works, need help with the 2nd part.

You could even add the emailing part after each workbook is created (but i dont know how to do that).

Thanks much.

[alansidman]

I have no idea if what the OP is requesting is even possible. If you think you have a viable solution, then please jump into the pool.

http://www.excelforum.com/excel-prog...tatements.html

I was thinking Select Case would work, but how many permutations and combinations would not be effective.

Alan

[:) Sixthsense :)]

OP is awaiting for any suggestion for the below thread.

http://www.excelforum.com/excel-form...ical-test.html

But I believe having the conditions and formula's in separate cells is something more complicated than editing the single cell IF function

[alansidman]

Here is a thread that has me shaking my head.

http://www.excelforum.com/excel-gene...urns-zero.html

OP wants a solution that does not use VBA and further wants a solution that doesn't use formulas. Wonder how that will happen. Magic?

Or am I just tired and don't understand the real issue.

[ChemistB]

Not sure why this is giving the OP issues with Refresh

http://www.excelforum.com/excel-form...two-cells.html

[ChemistB]

Anyone want to give this one a try? OP just threw a curve and my brain is fried.

http://www.excelforum.com/excel-form...l-summing.html

[ChemistB]

Can't wrap my head around this date problem

http://www.excelforum.com/excel-form...ndar-year.html

[ChemistB]

Looking for a solution (VBA I think) to integrating an import into existing data

http://www.excelforum.com/excel-form...e-records.html

[ChemistB]

This person is looking for VBA help to automate the creation of select pages saved to pdf

http://www.excelforum.com/excel-prog...-workbook.html

[ChemistB]

Drawing a blank

http://www.excelforum.com/excel-form...ntal-sort.html

[martindwilson]

time for a 2014 onwards?

[martindwilson]

udf required here i think
http://www.excelforum.com/excel-form...ont-color.html

[JBeaucaire]

Repeat after me: "Color is not data"

[jaslake]

@JB

I'm color blind and am not big on colors either

[ChemistB]

A puzzler

http://www.excelforum.com/excel-gene...g-formula.html

[jeffreybrown]

I don't have any idea how to create a formula solution here, any help would be appreciated...

http://www.excelforum.com/excel-gene...-question.html

[jeffreybrown]

I've lost the steam for this one and evidently I'm missing something...

http://www.excelforum.com/excel-prog...47#post3109847

[TMS]

Anyone got expertise using Solver willing to have a look at this:

Budget Quantity Formula

Or any other approach? oeldere suggested Solver and that sounds reasonable but I wouldn't know how to set it up.


Thanks, TMS

[arlu1201]

These date formats always elude me. The macro works but doesnt give the right output all because of the date formats. How do i correct it?

http://www.excelforum.com/excel-prog...age-box-2.html

[jaslake]

@arlu

Thread marked as SOLVED.

[arlu1201]

Yeah Zbor and Benishiryo assisted us with it. Thank you.

[TMS]

Anyone have a look at this. Thought it would be simple ... but, seemingly, it's not.

http://www.excelforum.com/excel-prog...sql-query.html


Thanks, TMS

[TMS]

Anyone care to pass comment or judgement on this:

Shared workbook does not display drop down list

Thanks, TMS

[Moo the Dog]

Hopefully someone can come up with a VBA solution to the OP's newest request here: http://www.excelforum.com/showthread...=1#post3115113

Thanks,
Moo

[daddylonglegs]

...and another VBA request - I have a formula suggestion that works - anybody care to produce a better approach with VBA?

[TMS]

@DLL: code provided and accepted.

Regards, TMS

[FDibbins]

any-one got time to look at the file on post #29? over cell A2 there is an object which I am unable to grab/click on. The OP says it was a calendar drop-down they had there that doesnt work now.

can a) anybody help to remove the object, and b) suggest a way for the OP to have a drop-down calendar in/over A2?

Thanks
Ford

edit: LOL rookie mistake...

http://www.excelforum.com/excel-form...n-choices.html

[JosephP]

@Ford
which thread are you talking about?

[martindwilson]

tahoeast you're right this thread is for members to call for help solving someone else's thread when stuck, not to bump your own problem
er where did it go?

[JBeaucaire]

EXCEL truncates CSV files if a "dash" is in the first character of any line in the file. This thread is a new puzzle. Any ideas?

[martindwilson]

some advice here please
http://www.excelforum.com/excel-gene...ng-a-cell.html

[daddylonglegs]

I don't do pivot tables - anyone want to jump in on the last query here?

[jeffreybrown]

Anybody have any thoughts on this...

http://www.excelforum.com/excel-gene...18#post3118718

[zbor]

Can someone jump in please: http://www.excelforum.com/excel-prog...code-help.html

[alansidman]

I've exhausted my VBA knowledge with this OP. Needs a tweak to the formula. Are you able to assist.

http://www.excelforum.com/excel-prog...iple-rows.html

[martindwilson]

any one fancy some merged cells code
http://www.excelforum.com/excel-prog...olorindex.html

[Kyle123]

Nope, merged cells are dirty

[RHCPgergo]

I'm really curious what the right method is for this one.
http://www.excelforum.com/excel-prog...-formulas.html

[JBeaucaire]

I may be missing the simplicity of the OP's question in this thread, I don't seem to be giving him usable answers. Anyone want to review this?

[Pete_UK]

Can anyone make any sense of what the OP wants in this thread? :

http://www.excelforum.com/excel-form...ifference.html

Thanks,

Pete

[ChemistB]

The OP wants the formula bar to open up wide enough to show all the lines in his cell (assuming maybe a max of 10 lines) automatically.

http://www.excelforum.com/excel-gene...ll-2010-a.html

[ChemistB]

Feeling brain dead on this one. Should be relatively easy

http://www.excelforum.com/excel-form...e-entries.html

[martindwilson]

any idea why enter doesn't work on =hyperlink() in excel 2010?
http://www.excelforum.com/excel-form...e-missing.html

[jeffreybrown]

I agree with abousetta, sounds like this could be a tricky formula which I'm sure one of you has a fix...

http://www.excelforum.com/excel-gene...xt-values.html

[JBeaucaire]

This OP is looking for assistance with a formula-based data validation back door, rather than the standard DV methods I have offered. Any other ideas?

[ChemistB]

Any way to return multiple matches with this?

http://www.excelforum.com/excel-form...ring-text.html

[arlu1201]

Not able to understand the OP's requirements here -
http://www.excelforum.com/excel-prog...and-paste.html

[dredwolf]

Anyone able to help this OP? :http://www.excelforum.com/excel-form...48#post3133648
I just can not get what they want

[:) Sixthsense :)]

Any one have any suggestion for the below link.

http://www.excelforum.com/excel-form...el-2003-a.html

I am unable to find the root cause of this error, since I don't get any error

[martindwilson]

i'm just not seeing this
http://www.excelforum.com/excel-form...per-value.html

[jeffreybrown]

Anybody have a better solution than adding these SUMIFS together?

http://www.excelforum.com/excel-form...12#post3136212

[Norie]

I'm really lost on what the OP wants here.

I think I might have missed the point entirely, not unusual.

[martindwilson]

another one i'm just to weary to look further
http://www.excelforum.com/excel-form...nd-column.html

[martindwilson]

some vba skills needed here,i thought it was just a defined named range but.......
http://www.excelforum.com/excel-prog...med-range.html

[jeffreybrown]

It seems I missed this one after the title change, but now simply too busy...

Anybody have some spare time to offer...

[JBeaucaire]

Any ideas here?

The OP is trying to save a CSV file but use the delimiter as a semicolon, which he says he has setup already in his computer's Regional settings. The SaveAS CSV with Local:=True is supposed to make that work, but in his case it still isn't. Your additional thoughts are welcomed on it.

[arlu1201]

I thought this was something i could do - but when attempted - i was lost - please help -
http://www.excelforum.com/excel-prog...tive-cell.html

[Fotis1991]

I have to say that i give up...

Can someone explain to our friend here how to drag-copy down a formula from a cell??

http://www.excelforum.com/excel-new-...ir-length.html

[tigeravatar]

I provided a solution for this thread: http://www.excelforum.com/excel-prog...11#post3149811

But apparently there is some sort of .txt file versioning issue? I'm not sure what's causing it or how to fix it. Would appreciate it if somebody could take a look or offer an alternative solution that doesn't run into the problem.

[jeffreybrown]

I'm drawing a complete blank on this chart thread

[alansidman]

What started out as a simple request has evolved into something that is over my head. I am not even sure what the OP is doing here. If you are up for a bit of a challenge, then jump in with both feet.

http://www.excelforum.com/excel-form...ells-data.html

Thanks

[arlu1201]

Need help here http://www.excelforum.com/excel-prog...f-of-mail.html

Thank you.

[arlu1201]

Can someone plz help here with a pdf renaming issue - http://www.excelforum.com/excel-prog...pdf-files.html

[JBeaucaire]

I'm not asking for anyone to jump into the thread (though you're certainly welcome to), but can anyone help me decipher what this guy is talking about?

[JBeaucaire]

Anyone ever used images in data validation? I've never played with that nor if it's possible to do that with dependency.
http://www.excelforum.com/excel-prog...down-list.html

[dredwolf]

Can anyone help here?
I have never heard of this happening, and have been completely unsuccessful in recreating the problem

[:) Sixthsense :)]

I have tried to write code in several methods to group the data but unable to achieve it and finally I am posting it here....

http://www.excelforum.com/excel-prog...mpty-cell.html

myself also awaiting to see the code

[:) Sixthsense :)]

The below thread is about one of the user of a shared workbook needs to know if any change happens in that shared workbook by way of messagbox notification.

I just share what I thought to achieve it.

1) On WorkOpen EACH SHEETS used cells count needs to be stored in a Module ARRAY Variable (Two Dimensional Array Like WsCelCnt(SheetName,UsedCellsCount)
2) Timer Needs To Be set For each 10 seconds and which will run for that user alone by verifying the username

application.UserName

3) On every 10 seconds the shared workbook of that USER ALONE needs to be saved and LOOPING needs to go on every sheet and get the count of each sheets used cells count
4) compare BOTH the ARRAY VARIABLES (Module Level Array Variable and Procedure Level Array Variable) and if both doesn't match then show a message to THAT USER ALONE (application.UserName).

I am not having that much of proficiency in vba and doing all those things may take a day for me. So thought to post it here and may be even simple solution may be there which I am not aware

http://www.excelforum.com/excel-prog...lls-excel.html

Thanks for looking it

[jeffreybrown]

I'm losing the battle on this one

Any help would be appreciated...

[FDibbins]

Can any-one help with this? I cant even make out what the OP wants?

http://www.excelforum.com/excel-form...n-the-row.html

[dredwolf]

Anyone able to help OP here :http://www.excelforum.com/excel-form...16#post3183916 ?
I tried my (VERY) limited VBA on it and kept getting wrong answer..

[Jacc]

I frequently miss to answer threads cause once you take a look at it in the CP it does not register as new post anymore and I forget all about it.

This should be a fun array formula for anyone who is a bit sharper than me, I'm out of ideas and it's way overdue. I hope it's not to late for OP.

http://www.excelforum.com/excel-form...d-columns.html

[ChemistB]

A permutation solution needed here

http://www.excelforum.com/excel-gene...ique-rows.html

[alansidman]

I got the OP on the right track, but the next VBA issue is beyond me.

http://www.excelforum.com/excel-prog...-commands.html

[alansidman]

Look at this thread as the solution I offered the OP was not appealing to him, although it is perhaps the quickest and easiest in my mind. But that may be because I am comfortable with databases which is not the case with many excel users. Perhaps you have something else that is more in line with what he is looking for.

http://www.excelforum.com/excel-prog...ent-files.html

[JBeaucaire]

This thread is about web connect refreshes that "won't". Any insight is welcome.

[FDibbins]

HI, Im trying to get a hyperlink to another sheet to work, referencing a formula in another cell (could become part of the H/L though), cant seem to figure it out

http://www.excelforum.com/excel-gene...condition.html

Im trying to use a reference from A2&A4&A6 for the hyperlink, and giving the sheet name/s the same as the results of the D/D

[arlu1201]

Am just not getting what the OP is saying - maybe someone can help - http://www.excelforum.com/excel-gene...ng-series.html

[TMS]

Can anyone offer their thoughts on an approach for this:

formula to auto update cells below when inserting a new row

Thanks, TMS

[FDibbins]

hmm can anyone figure out what this OP wants?

duh a link would help...

http://www.excelforum.com/excel-prog...30#post3200830

[daddylonglegs]

hmm can anyone figure out what this OP wants?

Link?! .

[:) Sixthsense :)]

OP wants only VBA solution for the below thread, but I don't know the need to go for vba. I hope someone can fix it

http://www.excelforum.com/excel-prog...nd-button.html

[:) Sixthsense :)]

I am unable to fix the root cause of this error
http://www.excelforum.com/excel-gene...el-2010-a.html

[:) Sixthsense :)]

Any suggestion for this one?
http://www.excelforum.com/excel-gene...bordering.html

[:) Sixthsense :)]

Another one which I am unable to fix
http://www.excelforum.com/excel-gene...-not-dele.html

[FDibbins]

Can any-one shed any light on this 1?

http://www.excelforum.com/excel-gene...paste-etc.html

[:) Sixthsense :)]

Is there any best method is there for creating Dependent Drop List (3 Levels) when the categories are huge
http://www.excelforum.com/excel-gene...down-list.html

[:) Sixthsense :)]

I am unable to fix which setting causing sheet tabs not showing in display, any suggestions

http://www.excelforum.com/excel-gene...-in-excel.html

[ChemistB]

Need a VBA solution that looks at numerical values and digit by digit converts them to a alpha character (in reverse order) based on binary.

http://www.excelforum.com/excel-form...ary-value.html

[:) Sixthsense :)]

Anyone Please correct me if I am wrong

http://www.excelforum.com/excel-gene...ing-cells.html

[TMS]

@Sixthsense: No, you wouldn't use Sheet Protection. You'd just use the Selection Change event to manage which cells the user could access. If a selected cell has data in it, you'd bounce it somewhere else.

Tested, briefly, in a non-shared workbook:

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim cell As Range
Dim bDataPresent As Boolean
bDataPresent = False
For Each cell In Target
    If cell.Value <> "" Then
        bDataPresent = True
        MsgBox "you cannot edit cell " & cell.Address
    End If
Next ' cell
If bDataPresent Then
    Application.EnableEvents = False
    Range("A1").Select
    Application.EnableEvents = True
End If
End Sub

Regards, TMS

[arlu1201]

Dont know how i missed this one but i really dont have the time to work it out. Can someone please pitch in - http://www.excelforum.com/excel-prog...fic-info.html?

[tigeravatar]

I suggested data validation for this thread, but it doesn't look like that what the user is going for. Anybody up for a macro work-around/solution?

[:) Sixthsense :)]

I am not getting any idea how to achieve this one Any suggestions???

http://www.excelforum.com/excel-form...t-of-debt.html

[shg]

Works fine for me in Excel 2007.

Abousetta, when you post code that changes the Excel environment, you should also post code to restore it.

style = GetWindowLongPtr(hWnd, GWL_STYLE) Or WS_BORDER
ret = SetWindowLongPtr(hWnd, GWL_STYLE, style)

Or make the code toggle it:

style = GetWindowLongPtr(hWnd, GWL_STYLE) Xor WS_BORDER

[martindwilson]

anyone good at counting parenthesis?
http://www.excelforum.com/excel-form...f-formula.html

[FDibbins]

umm holy...cr^&*()_ Martin!!

[tigeravatar]

I don't think the OP is listening to me anymore, anybody have a different solution?
http://www.excelforum.com/excel-form...html?p=3230851

[:) Sixthsense :)]

OP wants to have a Multi Select Combo Box like Pivot Table Drop Down selection. Any suggestions?

http://www.excelforum.com/excel-prog...tion-list.html

[:) Sixthsense :)]

Not getting any idea for this one Any Suggestions?

http://www.excelforum.com/excel-form...ange-list.html

[alansidman]

I have looked over this OPs issue and cannot find anything wrong with his methodology in using the Countifs function. It does not return the results when employed in Column D on the Summary sheet for Accounts Labor and Tax. Very strange. Maybe someone will see something glaring. I could not.

http://www.excelforum.com/excel-form...9-countif.html

[dredwolf]

OP wants users to be able to copy values, but not formating...not sure how to do this my self....
http://www.excelforum.com/excel-form...84#post3236084

[FDibbins]

http://www.excelforum.com/excel-prog...40#post3233240

DV in AP4:AR4 to turn red if all empty, or if more than 1 cell is filled. works fine except there if there are 2 and you delete 1 (leaving 1) they dont all turn white until you enter something - anything - somwhere else??

[martindwilson]

http://www.excelforum.com/excel-form...a-polygon.html
a bit of trig anyone?

[icestationzbra]

anyone fancies the challenge?

http://www.excelforum.com/excel-form...ease-help.html

[TMS]

Anyone got any thoughts on this:

Having a problem stepping through VBA and setting breakpoints at same time


I'm all out of guesses.

Thanks TMS

[tigeravatar]

I'm kind of lost on this one, would appreciate it if somebody took a look here:
Statistically significantly higher than average

[:) Sixthsense :)]

I thought I can (If the data structure is constant), After seeing the data structure I decided to post here for help

http://www.excelforum.com/excel-form...o-another.html

[:) Sixthsense :)]

Seems to be a Challenge, Anyone can provide single cell formula?
http://www.excelforum.com/excel-form...html?p=3244372

[JBeaucaire]

Anyone good with forms want to take a peek here?

[:) Sixthsense :)]

Any suggestions, how to make this code to run faster
http://www.excelforum.com/excel-prog...un-faster.html

[JBeaucaire]

Can't quite get this one... need an array formula.

a) Start dates in column A
b) end dates in column B, if any
c) sequential list of dates in column C

Goal in column D, based on the date in column C, find the oldest order that was still open on that day and list how many days it's been open up to the col C date.

[abousetta]

Question regarding capturing download URL when the response is not immediate from the server (http://www.excelforum.com/excel-prog...54#post3247754). Can anyone assist the OP?

abousetta

[arlu1201]

Can someone help the OP here http://www.excelforum.com/excel-prog...tionality.html ?

Thanks

[:) Sixthsense :)]

OP is not ready to change the data structure and wanted to stick with junk approach, anyone is interested to take us this challenge?

http://www.excelforum.com/excel-form...la-lookup.html

[:) Sixthsense :)]

Anyone please take this formula challenge, seems to be simple but I am not getting any idea

http://www.excelforum.com/excel-form...s-a-table.html

[:) Sixthsense :)]

I don't know any abc about chart anyone please take care of this thread please...

http://www.excelforum.com/excel-prog...-data-set.html

[ChemistB]

For anyone who's brain is still working, complex array formula (or come up with a better way)

http://www.excelforum.com/excel-form...-formulas.html

[:) Sixthsense :)]

I don't know how I can help further...

http://www.excelforum.com/excel-form...sion-wise.html

[alansidman]

Is there a viable solution for this OP?. Do you know of one? Probably a complex VBA solution, I'm guessing. Out of my range of knowledge.

http://www.excelforum.com/excel-prog...ted-cells.html

Alan

[TMS]

For my own peace of mind, would someone care to take a look at this thread and explain what has happened ...

HELP ME Wierd display, can't change sheet

I have provided a "get out of jail card" for the OP in that I have copied all the sheets and code to a new workbook.

If you download the example, you will find that the display in Excel is exactly as described in the OP. However, you can open other workbooks, or create new workbooks, and they behave normally.

I have never seen anything like this and everything I have tried, other than creating the copy, has failed.

I would be intrigued to see a solution to this issue.

Regards, TMS

[abousetta]

Anybody with a scanner and know vba what to help the OP debug the code. It works fine, but once he scans another item, it triggers a worksheet_change event and bypasses the need for the OP to intervene (http://www.excelforum.com/excel-prog...88#post3255588).

Thanks.

abousetta

[ragulduy]

http://www.excelforum.com/excel-prog...html?p=3256083

Not a clue what to do on this one. Seems to work ok with my setup (2003/XP) but looking on google it seems that the method no longer works for (2007/Windows 7). Could do with someone with newer software to take a look at it.

[Norie]

Can someone take a look at this?

http://www.excelforum.com/excel-prog...dropdowns.html

The only way I can think of doing it is with some massive, crazy unworkable formula.

I've got a feeling I'm missing something though.

[ragulduy]

Norie - your link goes to the subscription page...

[Norie]

Fixed it.

[FDibbins]

I think I have resolved this 1, But Im still stumped on whats causing the problem.

http://www.excelforum.com/excel-gene...-is-a-sum.html

[:) Sixthsense :)]

Any suggestions about how to get certain fields of website using web query through VBA?

http://www.excelforum.com/excel-prog...-from-web.html

[MarvinP]

Hi,

I need someone who still is using Excel 2003 and has the Calendar control on their system. This OP has a very elaborate Userform (with tabs and groups of controls). He wants to sum the values in a bunch of the text boxes on his userform. I simply can't open his .xls without the calendar control and I'm not good enough at Tabs on a Userform to be much help.

See his thread at http://www.excelforum.com/excel-prog...much-code.html

He is still on me for an answer.....

[jaslake]

@MarvinP

The OP has posted an .xlsm File...not Excel 2003????

[MarvinP]

I still don't have the Calendar control or some add-in that is needed to work on his Userform.

[abousetta]

Can anyone with Office 2007 try the attachment (http://www.excelforum.com/excel-prog...=1#post3273149) .

what you should see is in this image (http://www.excelforum.com/attachment...5&d=1370788367).

[abousetta]

Thanks shg. I honestly didn't know that the style could be reversed. The MSDN page on Windows Styles (http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx) states that "After the window has been created, these styles cannot be modified, except as noted". I took that to mean that once I remove the border, I can't put it back without redrawing the window.

Now that I know better, I will update the code. Also I will investigate "Xor" as I have never seen that before.

Thanks again for sharing.

abousetta

[abousetta]

Me again...

Follow up to post #165, the solution works fine in some versions of Windows but not XP. Does anyone know how to remove the three uppermost buttons (minimize, resize, close) in Windows XP? The thread is located here (http://www.excelforum.com/showthread...=1#post3273423) and what you should see is in this image (http://www.excelforum.com/attachment...5&d=1370788367).

Thanks.

abousetta

[MarvinP]

Does this help?
http://social.msdn.microsoft.com/For...3-1bd4359dc2ed

[abousetta]

Thanks MP. I was able to remove the minimize button, but not the other two. XP seems to be a species of its own kind.

[abousetta]

With Windows XP, I found that I have to hide the ribbon in order to hide the three buttons. I don't know the logic but I left an example for the OP. Hopefully it will resolve her issues.

[:) Sixthsense :)]

I am unable to understand the OP's requirement of this thread

http://www.excelforum.com/excel-gene...ping-data.html

[:) Sixthsense :)]

Another one which I am unable to fix

http://www.excelforum.com/excel-gene...t-too-big.html

[Mordred]

I have no clue what this user wants now so please check this thread out if you want to take a gander at it. I came up with an original solution but now the requirements have changed and I don't understand them anymore.

[Mordred]

I don't know if anyone has looked at this thread or not but I can't make head nor tails of how to go about this one.

[ChemistB]

Is this a known bug?
Not sure what the OP is talking about with the "Developer tools" being used to unlock cells.

http://www.excelforum.com/excel-gene...t-working.html

[tigeravatar]

Can somebody have a look here?
http://www.excelforum.com/excel-prog...tes-times.html

I posted a solution and the compatiblity checker doesn't give me any problems, but the OP states the formula results in a #NAME? error when he opens the workbook using Excel 2003

[Ace_XL]

A few lines of code will get this done..?

http://www.excelforum.com/excel-form...character.html

[ChemistB]

I wrote a UDF that sums values but doesn't seem to work for values < 1. Not sure what I did wrong.

http://www.excelforum.com/excel-form...ease-help.html

[Moo the Dog]

I wrote a UDF that sums values but doesn't seem to work for values < 1. Not sure what I did wrong.
http://www.excelforum.com/excel-form...ease-help.html

Does it have anything to do with: "Dim i as Integer" in the code, as opposed to a format DOUBLE for example, that handles decimals? I dunno...

- Moo

[JBeaucaire]

Neither LONG nor INTEGER variables use decimals, those are both whole number variables. Dim the variable as DOUBLE if you need decimal values.

[Moo the Dog]

Neither LONG nor INTEGER variables use decimals, those are both whole number variables. Dim the variable as DOUBLE if you need decimal values.

Oops! You're right.. I meant DOUBLE... sheesh. Long day!

- Moo

[daddylonglegs]

You got the OP to the correct solution in the end XOR LX - job done, reputation added......

[abousetta]

Depending on the precision needed you can use single or double (http://msdn.microsoft.com/en-US/libr...v=VS.80).aspx)

[FDibbins]

@ btmtdk this thread is for members that are answering questions, to ask for help. Please do not ask for assistance on your own thread here

Thanks

[jaslake]

The Code in this Thread is causing issues for the OP that I can't duplicate on my platform. If you are kind enough to look at the Thread you'll see that the issue is in the WorkBook Open Event. The Workbook opens fine on my platform but the OP gets an error message each time (s)he opens the File.

http://www.excelforum.com/excel-prog...ded-range.html

The Code in the Workbook Open Event is an adaptation from Post #4 of this link. It assigns a Macro to the Row Right Click Insert Event such that a new row gets inserted on EACH sheet in the workbook upon selection of Row Right Click Insert.

http://www.mrexcel.com/forum/excel-q...row-event.html

Any insight is appreciated.

Sorry...the operative Sheet is Target Labor and please note that the lines are off by -1 line on all other sheets.

[abousetta]

Hi Jake,

The only error I got was that EndRow was not declared as long. Else than that it seemed run fine from what I could tell.

abousetta

[jaslake]

@ abousetta

Uploaded a new file...please look at the Thread again...been playing with it a bit too long and had a bit of brain freeze. EndRow was declared as long in the Globals Module...for some reason I commented it out. Does the new File function for you as expected?

http://www.excelforum.com/excel-prog...ded-range.html

[Mordred]

Another case of requirements that change after a post right here. Sheet side formulas are not my strong spot so please have a look.

[alansidman]

Not sure what is wrong here. Perhaps someone with more VBA expertise can see the issue.

http://www.excelforum.com/excel-prog...ime-error.html

[dredwolf]

@ alan
Your posted code also forgot the ".."

[Mordred]

This thread started off looking for the last row, turned into I don't know what, and is now a look for the last column. I've suggested 3 times to upload a workbook but the OP hasn't said yay or nay to my request and I'm put off.

EDIT: The OP has finally uploaded a workbook and everything I have done for him/her is working according to what he/she has asked. I don't get what this person wants, at all so I'm permanently stepping away from this one.

[Fotis1991]

Anyone that interest to continue here? i Just...gived up!

[Mordred]

If someone can help here and also moderate there I'd appreciate it. It turns out that I have actual work to get done and I can't put the time into this.

[jeffreybrown]

The OP is happy with the solution(s) provided here, but not when using on Excel:MAC 2011.

Anybody have the availability is look into this?