If you Google: excel vba worksheet rename event ... you get a few suggestions, mostly from other forums though so I hesitate to provide links.
It's a bit of a botch up but it looks like it could be done.
Regards, TMS
If you Google: excel vba worksheet rename event ... you get a few suggestions, mostly from other forums though so I hesitate to provide links.
It's a bit of a botch up but it looks like it could be done.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You could count the characters in the tab and, if deficient, issue your message or repair it right there!![]()
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Counting characters alone wouldn't be enough; you'd need to check the content/structure, perhaps with a Regular Expression. But what would prompt you to check it?
Best bet would be to lock the workbook structure and have button to create new sheets.
Regards, TMS
???![]()
Please Login or Register to view this content.
Day and Month could be in the wrong order, the Year could be two digits. Missing/extra hyphens ...But what would prompt you to check it?
Hey Trevor, the OP's post just shows omissions in the two digit month field![]()
I think not. Look again. At least two no-no's but I suspect lots more possibilities.
Hi Trevor,
I looked again: You're right but
Length 9=> omitted first zero
Length 8=> omitted the 20 for the year
Length 7 => omitted both
You could still work with it!
Probably easiest would be to format it "mm-dd-yyyy".
Well I played with the notion but, with appropriate safeguards:
works rather nicely![]()
Please Login or Register to view this content.
![]()
Last edited by xladept; 07-03-2014 at 04:17 PM.
op wants to fill in an allocation table and update a planner OR update the planner and it fills out the allocation table cant really see the second bit myself, any ideas peeps?
http://www.excelforum.com/excel-gene...orksheets.html
Last edited by martindwilson; 07-02-2014 at 07:53 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Martin,
can't see which thread you are referring to.
Pete
that would help wouldn't it
http://www.excelforum.com/excel-gene...orksheets.html
Seems an array formula is required in this thread... Any suggestions, Sktneer?
Take part information from a cell to create a formula
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Looks like another array formula is required for the OP of this thread : Formula Not Recognising Cells as Blank with Formulas that Return Empty Text
Any ideas for the OP's requirement in this thread? Calculations based off formula from another cell
Anyone have time to look at this? I just don't seem to be able to get my head around the requirement.
Counting the number of occurrences before the current week #
Thanks TMS
Trevor,
looks like he had his " in the wrong place.
Pete
@Pete: thanks for looking ... wood for trees and I don't think the workbook helped me much![]()
Can anybody extend help for the OP in this thread ?? : Depleting From Multiple Values At Once
I'm not sure if my nesting 24 =SUBSTITUTE()'s is really the best way to go about this problem, any help for this op?
http://www.excelforum.com/excel-gene...haracters.html
Last edited by Speshul; 07-15-2014 at 03:05 PM.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
This OP is trying to understand why his (IMO erroneous) number format gives a different display in the spreadsheet than in the chart. I cannot really confirm his observations in my own version and I don't have 2013. Any takers?
http://www.excelforum.com/excel-char...ts-y-axis.html
Originally Posted by shg
Can someone help with this mailmerge problem. OP is unable to upload file. What he wants to do is produce letters to each of 1500 employers to 9000 employees based on who the employer is. A Word problem perhaps but I think he's right by raising the question here because of the need to manipulate the data document in Excel.
http://www.excelforum.com/excel-gene...ail-merge.html
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
OP is trying to use hyperlink() function with root paths which have more than 255 characters.
But unfortunately the Link Location argument of Hyperlink() function accepts maximum of 255 character length only.
Any suggestion will be helpful to the OP
http://www.excelforum.com/excel-form...mla-value.html
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
OP asked for something "brutally simple", so I suggested a filterable list using Autofilter. I don't do "database" stuff, so I haven't got much more to suggest to him. http://www.excelforum.com/excel-gene...iles-here.html
Can anyone suggest another approach?
Anyone with access to EXCEL 2003, can you download the workbook solution I've provided in this thread and see if you're seeing the same issue the OP is seeing. We are applying an Autofilter to a range based on a search string typed in H2.
Here's the file in case you don't have access to that thread.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I have stepped in something terrible. Pretty sure its programming related.
https://www.excelforum.com/showthread.php?t=1028374![]()
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hi Jerry,
What I found to be weird about the demo file is that each criterion is listed in every first few cells in the H range - otherwise it seems to work![]()
Last edited by xladept; 07-31-2014 at 06:07 PM. Reason: Typo in body
@JB,
I believe this will resolve issue:
![]()
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Anyone have experience of refiltering OLAP pivot tables with VBA / parameters?
http://www.excelforum.com/excel-prog...-function.html
Reading http://support.microsoft.com/kb/234700 would indicate that normal methods of refiltering pivots won't work - as I've found, eventually, after going through all the usual steps of trying to get code to work...
Anyone?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This is worksheet change event and it is a bit out of my wheelhouse. Hopefully, you can get the OP on the right track.
http://www.excelforum.com/excel-prog...er-column.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This OP is created an excel file by referencing the formulas to the desktop file. The issue is that the desktop root path will get differed to each persons which is creating an issue by showing the Update Link popup message.
OP looking for automatic adjustment of desktop link in formulas.
OP is eagerly waiting for the solution for this issue.
http://www.excelforum.com/excel-gene...reference.html
I tried a few things but couldn't get it to work....anybody?
thanks
http://www.excelforum.com/excel-prog...in-column.html
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Requires Array formulas and no helper columns
http://www.excelforum.com/excel-form...condition.html
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi all,
Any ideas for forcing this formula to re-calculate in Automatic Calculation mode?
Usually just an additional clause, e.g. with NOW(), forces the issue, though I can't get anything to work here.
Cheers
http://www.excelforum.com/excel-form...ml#post3796764
Anyone want to help out with this 1?
http://www.excelforum.com/excel-form...to-column.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Any one have any idea why the code in this
Thread will not work in 2013 works fine
In 2007
http://www.excelforum.com/excel-prog...onversion.html
@Martin
I think the problem is you have a reference to the solver in your workbook that will probably be missing in 2013. So the str() and trim() functions will be undefined. You need to either remove the reference or add a parent to the str/trim (e.g. conversion.str / strings.trim)
@Martin: I couldn't find the reference so I just unticked the MISSING Solver.xlam reference. Compiled OK after that with no other changes.
And, as it implies, 79228162514264337593543950245 is the highest number but you need to convert it with:which returns: 111111111111111111111111111111111111111111111111111111111111111111111111111111111111111110100101Formula:
Please Login or Register to view this content.
Regards, TMS
Last edited by TMS; 08-12-2014 at 07:12 AM.
In this Thread OP gets a Type Mismatch error in response to a Message Box. I've tested in Excel 2007 and 2010 and the Code performs as expected. OP uses Excel 2013 and is receiving Error 13.
Any of you with Excel 2013 have time to look? Thanks.
http://www.excelforum.com/excel-gene...ml#post3800110
Note to Mod/Admin...I posted to the wrong Sub Forum. Would you please move to Call In The Cavalry.
Last edited by jaslake; 08-13-2014 at 11:23 AM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Anyone able to help here:
http://www.excelforum.com/excel-form...-counting.html
This should be a simple "count if" but I'm just not understanding the OP's requirements.
Need a fresh set of eyes on this one:
https://www.excelforum.com/showthread.php?t=1031643
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I think the OP said you solved it with one small change to your last formula?
Everyone who confuses correlation and causation ends up dead.
This is going to be a simple AND() Function usage but I am unable understand the OP's requirement
Anyone please help with this below thread
http://www.excelforum.com/excel-form...of-values.html
Any Google Docs oficianados care to take a glance at this one, OP is trying to use INDIRECT() which is supposedly a usable GD function.
http://www.excelforum.com/for-other-...-formulas.html
Could use help on this one
http://www.excelforum.com/excel-form...lp-needed.html
Not sure on this one, I think it's possible but my attempt is giving me confusing results.
http://www.excelforum.com/excel-form...ml#post3814241
He wants to rank by the Average of each row, but within one formula per row (no helper columns).
I think this one will require laying out the data as the OP suggests or VBA but I'd love to see a formula solution
http://www.excelforum.com/excel-gene...ertically.html
Hi all.
Didn't notice that the OP had posted to the VBA section on this one, so offered a formula-based solution, which turns out to be inappropriate for the size of the dataset that the OP has.
Said I'd bump it for them to anyone with expertise in VBA and willing to have a go.
http://www.excelforum.com/excel-prog...al-amount.html
Thanks a lot.
As far as I can understand with this question, I solved it in post #3.. It is now on post #25. Can someone else take a look at this, before I lose my mind?
http://www.excelforum.com/excel-gene...me-cell-2.html
Busy with other projects, won't be on here much for a bit. Can someone take this one?
http://www.excelforum.com/excel-gene...-a-series.html
This was more than I expected from the OP....anybody want to give it a go?
http://www.excelforum.com/excel-prog...ml#post3824784
Lord have mercy. Someone. Please. Help.
http://www.excelforum.com/excel-gene...ml#post3826744
Anyone with ADO connectivity experience that can comment on this thread?
Op is trying to read text from closed workbooks, and apparently the text is huge per cell, they need to be able to pull out more text than 255 characters, and the workbook takes too long to actually open/close.
Any help at all is appreciated, I have no exp with ADODB connections and pulling large text from closed workbooks.
This one is going to be a simple formula logic but understanding the logic is something very hard to me.
Anyone please jump in this thread to solve this OP's issue
http://www.excelforum.com/excel-form...-are-true.html
Does anybody understand this 'cause I don't
http://www.excelforum.com/excel-prog...the-macro.html
Never use Merged Cells in Excel
This one will require VBA
http://www.excelforum.com/excel-form...-column-f.html
No idea what could be causing this - anyone encountered anything similar before?
http://www.excelforum.com/excel-prog...-cut-keys.html
Macro apparently runs fine when called directly, but "just stops" part way through when called via keyboard shortcut...
I'm inexperienced at the connections changes this thread is dealing with, can anyone offer suggestions I cannot?
Since I just use Rob Bovey's chart labeler add-in, I'm not very familiar with the code behind it, and this OP claims that he cannot use third party add-ins for the task. If he needs further help developing the procedure for this, can someone step in and help him?
http://www.excelforum.com/excel-prog...ta-labels.html
I think this OP has basically filled out the "make lookups harder" bingo card.
1) Two-column lookup to return third column
2) Indeterminate column depth, maybe
3) Return multiple matches?
4) Check all the worksheets for matches
I'm a little too intimidated to even ask questions to specify the things I'm not sure about, and get kinda, committed to answering.
@ben_hensel: not sure there's a barge pole long enough with a description like that. Good of you to highlight it though![]()
Yeah, I read that and moved on too. My brain can't handle it today.
http://www.excelforum.com/excel-prog...logy-tool.html
I've exhausted my ideas for this OP's request. You got any?
http://www.excelforum.com/excel-char...eto-chart.html
this OP says that she really wants a pivot table solution. I expect it can be done, but I have no experience with pivot tables. I think the solution I proposed will work, but, if anyone who knows pivot tables could chime in and show her how to do it with a pivot table/chart, it could be a better solution.
On behalf of xladept:
Can anyone help with this concept?
Dependent Drop Down lists - INDIRECT()
Dependent Dynamic Drop Down Lists - OFFSET()
The OP in this thread is searching for a way to do it without either of these functions, which I have never found.
If anyone wants to jump in on this one, I wouldn't complain.
http://www.excelforum.com/excel-form...combining.html
@ChemistB - no thank you/dynamic requirements![]()
A simple form question has stumped us, trying not to need the OP to post the form... guess I should just do that.
http://www.excelforum.com/excel-prog...-text-box.html
A pretty advanced topic, IMO, thought I'd draw some more eyes to it.
http://www.excelforum.com/excel-prog...t-methods.html
I came across that thread and if we resolve the current issue (Disabling the Insert/Delete From Right Click) then the next question will be disabling the Ctrl++ and Ctrl+- from the Keyboard which requires Application.Onkey method.
Even if we do that then the next question will be raised from the OP that this should happen on that sheet alone. So we have to enable the Application.Onkey on deactivation which needs lot of follow-ups, so I thought to stay away from that thread![]()
Can anyone have a look at this please: Delete fifth Name
I provided a relatively simple formula solution to extract the first four elements (space separated) from a cell.
Formula:
Please Login or Register to view this content.
And the OP seemed OK with that but then came back with a much more complex formula that he wants/needs to adapt.
Formula:
Please Login or Register to view this content.
Lost on me, I'm afraid.
Thanks, TMS
Odd problem here - unable to refresh data queries on a protected sheet, despite unprotecting first, or protecting with userinterfaceonly=true...
http://www.excelforum.com/excel-prog...ry-tables.html
Calling once again, this OP has pinged looking for assistance on his one request, promising not to feature creep anyone. I've no idea or would jump in...
http://www.excelforum.com/excel-prog...t-methods.html
I used this code for dependent drop down list (Validation) based on the selection the next validation cell will be cleared and I used the sendkey method to auto populate the drop down.
But this is not working in MAC excel and throwing some errors to the OP.![]()
Please Login or Register to view this content.
After doing some google search I got the below link and I found the send key method for MAC excel and used it in the below code.
http://www.mrexcel.com/forum/excel-q...dkeys-mac.html
But unfortunately this also not working for the OP![]()
Please Login or Register to view this content.
Anyone have any suggestions? If so, then please join in the below thread
http://www.excelforum.com/excel-prog...r-changes.html
Any suggestions for updating hardcoded hyperlinks to broken destinations?
http://www.excelforum.com/excel-gene...auto-save.html
Something for the FORM wizards...
http://www.excelforum.com/excel-prog...a-project.html
Anyone have any suggestion about what's going wrong in JapanDave's code?
http://www.excelforum.com/excel-prog...n-columns.html
http://www.excelforum.com/excel-prog...-with-vba.html
I THINK the OP wants to resize a workbook window, within the (maximized) Excel application window. I only have 2013 on this PC, where every workbook opens in it's own Excel instance.
Anyone able to help?
Anyone care to pipe in here?
@JB: I think not. I have a mental picture of the thread with little round "bruises" all over it. That would be from the barge poles touching it.![]()
Not from my barge pole, I wouldnt even use yours, Trevor, let alone mine
What we have here is an attitudenal chism![]()
Is that similar to a schit attitude?
Yes - if the "c" is silent like P in PSmith![]()
No, Olly, I mean the one without a big grin![]()
Here is a well defined problem it seems and rather interesting. Surely there are lots of people here that can handle this? I can't/don't have time/bitten of more than I can chew etc.
http://www.excelforum.com/excel-form...-criteria.html
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Happy with my advice? Click on the * reputation button below
This OP has some EVENT code I've given for workbook_open and workbook_aftersave... they are looking to make that work from the Personal.xlsb file so they trigger on every workbook open and every workbook save event. I believe this will require some CLASS module assistance I've no real experience with yet.
http://www.excelforum.com/excel-prog...e-changes.html
This is a FABULOUS question, I have been poking at it unsuccessfully for an hour now.
http://www.excelforum.com/excel-form...e-formula.html
Doing this in VBA would be trivially simple. But the formula approach has be baffled. Maybe not doable at all.
=Randbetween(1,6)+Randbetween(1,6)
...is an easy way to simulate the total of 2 dice being rolled.
This OP want to put a number in a cell that represents the number of "rolls" and have a single cell formula that does that many rolls on the fly. This is not same single roll multiplied 3 or 20 times, it should be 3 or 20 individual rolls of the two dice, and the random results added up. The key cell can be changed to any number of "rolls" and the random roll summarizer does that many rolls in the one cell.
I'm baffled. Remember, I can knock out the VBA version, I'm looking for some brain power to help me ascertain, is it NOT doable by formulas only?
jBeaucaire I've put one solution up but you might want to test it.
Yeah, a brute force formula,. No way to do 100 rolls there...but thanks for input.
@ Jerry - formulas are not my thing, but aren't there array formulas that could be constructed to do n rolls??
You'd think so wouldn't you?
....but it isn't quite that simple - e.g. if you use this formula
=SUM(IF(ROW(A1:A100)<=B3,RANDBETWEEN(1,6)))
You'd think that might generate and sum the correct amount of random numbers, but if B3 is 20 that just generates the same random number 20 times. I don't think you can use a single formula without helper cells (barring the "brute force" approach), unless you turn on iteration as suggested by MrShorty.
Audere est facere
No 100 wouldn't work. OP asked for 20 and this does 21 actually but to do 100 then you could do this formula in 5 cells and add them which would give the same result.
But ..... If I was doing 100 I think I'd tackle this differently (other than the obvious vba solution) and try to fit a curve to the distribution curve for the roll options between 100 and 600 noting that they have different probabilities. I worked a curve out for three dice rolls but that only has 216 combinations between 3 and 18. 100 rolls has 6^ 100 which is beyond my comprehension. I'd be UDFing this one.
@ DDL -- you're saying that this only invokes the Rand() once??=SUM(IF(ROW(A1:A100)<=B3,RANDBETWEEN(1,6)))
Romperstomper has slain this dragon. I am so thrilled, something new accomplished today. *sigh*
It's 1am and I've had a few, so in a good mindset.![]()
Ok, I've been toying around with this for a few days and I'm thoroughly stuck.
https://www.excelforum.com/showthread.php?t=1043548
OP has a number of rows by Account, and wants to sequentially deduct a given balance from each until a line zeroes out. This is either actually a hard question, or something deceptively simple.
Any thoughts on this one?
Any thoughts about why the Status bar is not showing the Count,Sum,Average,Numerical Count in the excel status bar eventhough everything is enabled in Customize Status Bar Popup Menu
http://www.excelforum.com/excel-gene...ml#post3879494
Anyone any ideas about this one?
http://www.excelforum.com/excel-prog...nge-error.html
If posting code please use code tags, see here.
This one has me completely stumped.... how to add .CSV permanently to the list of "All Excel Files" extensions that are offered when you activate the OPEN FILE window from inside EXCEL. Currently it lists all the .xls? options only.
http://screencast.com/t/XHhZ7dnMk
any one fancy a bit of vba tutoring?
http://www.excelforum.com/excel-prog...p-problem.html
I tried to help this OP but the OP is not understanding the way I am trying to populate the data. I felt frustrated and not interested to go further, but I hope someone will take care of this post VBA question.
http://www.excelforum.com/excel-prog...ml#post3882114
This is going to be a Sumif() function solution but I lost my patience here and I am not interested to give solution. Anyone please take care....
http://www.excelforum.com/excel-prog...alues-vba.html
Anybody care to take a look at this: Fire up Worksheet_Change
Regards, TMS
I got most of what the OP wanted, but this thread has carried on for so long now that I am lost lol. They keep using different files (I think), Its aboyt different teams and players, and now they want a list of all players from teams selected. Im lost lol
http://www.excelforum.com/excel-form...riteria-2.html
I am officially in way over my head on this one. The OP marked thread [SOLVED]..........pre-maturely I'm sure.
Post #14 summarizes my concerns. If nothing else I am in serious need of leadership and guidance on this one.
http://www.excelforum.com/excel-gene...ttern-end.html
Thanks,
Dave
Edit: [SOLVED]. 01:34 AM 11/4/2014
Last edited by FlameRetired; 11-04-2014 at 03:35 AM.
anyone can help this person? I at least helped the OP to define his problem more.
http://www.excelforum.com/excel-gene...t-hlookup.html
thx. Sam
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Anybody want to jump in onthis 1?
http://www.excelforum.com/excel-prog...ml#post3893548
I have another 1 here that could use some help...
http://www.excelforum.com/excel-form...ml#post3894037
Please, can someone look at this Thread and test the Code in the attachment to post 24?
Make an entry into C12, entire Row 13 should unhide as it does on my platform...on the OP's it does not.
Thanks, I appreciate.
http://www.excelforum.com/excel-prog...hide-rows.html
@jaslake: something very strange is going on with this workbook/worksheet/code. I have put a Stop in at the top of the Worksheet_Change event handler. If I make a change in column A, it Stops, as expected. If I make a change in column C, it does not Stop. It does, however, convert a lower case x to an upper case X ... but it doesn't hide the rows.
I'm guessing it has something to do with the UDF HasCmt which is applied to all the range of interest. CF formula:applied toFormula:
Please Login or Register to view this content.Formula:
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
I note that when the UDF is commented out, my Stop is complied with. With the Stop working, you can step through the code. What is happening is that the first bit of code converts the content of the cell to Upper Case but the second Undo causes an error and goes directly to the Reset: label without executing the Unhide Row code. So, if you switch off the error trap you get Run-time error '1004': Method 'Undo' of object '_Application' failed.
That's the problem. What to do about it ... over to you. Maybe you can't have an undo stack in VBA because VBA routines clear the undo stack.
Regards, TMS
@Trevor
I appreciate you looking at this. I'm not certain what's going on but I'll remove the error handling and see where it leads.
I'll get back to you and the OP...probably not tonight...I truly do appreciate the feedback.
Thank you.
The OP on this thread has asked for second opinions:
http://www.excelforum.com/excel-prog...ingle-row.html
This is an Access Question: The OP has a table that he allows users to make changes to. I have advised him that this is a bad practice. I have also advised that no data should be removed from databases, but rather add a field to make a record inactive is the preferred db practice. The issue that the OP has, can code be written that is driven by changes to the table, similar to Worksheet_Change event in Excel. I am not aware of any VBA triggers from changes to Tables.
If you can help, please look at this link.
http://www.excelforum.com/access-tab...ess-table.html
I've never seen this before.
http://www.excelforum.com/excel-form...worksheet.html
OP is trying to clean up a long formula, which is sort of a SUMPRODCT/COUNTIF but with multiple strings as criteria.
Is it possible to use named ranges (of multiple cells) for criteria in a COUNTIF?
https://www.excelforum.com/showthread.php?t=1051788
This OP appears to be asking a simple Conditional Formatting question that I truly am not grasping... too much turkey in my system perhaps.
http://www.excelforum.com/excel-gene...ergen-map.html
Can anyone see the simple thing I am missing?
OP wants to bypass the Alert Message in IE 11
I don't know anything about HTML object and all, so anyone please take care of this thread
http://www.excelforum.com/excel-prog...ml#post3916115
OP wants to paste clipboard to ActiveCell, inserting rows to make room for however many cells are in clipboard.
Can't figure out a way to stop Excel from copying clipboard into every new cell in the inserted rows.
https://www.excelforum.com/showthread.php?t=1052424
Anyone want to have a go at this?
http://www.excelforum.com/excel-gene...formula-2.html
I don't have the time at the moment to look into this one, and it's certainly not a case for a single-cell solution, I would imagine.
Thanks a lot
I can't wrap my head around what he's asking for or doing here.
http://www.excelforum.com/excel-form...med-range.html
I am totally stumpped.. Can anyone help me.. to solve..
http://www.excelforum.com/excel-form...hree-rows.html
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Can anyone help with this?
http://www.excelforum.com/excel-prog...ml#post3920883
I'm out of ideas on this issue. If you are up to it--->http://www.excelforum.com/excel-prog...not-empty.html
Can anyone help here please?
http://www.excelforum.com/excel-gene...ml#post3928510
I have no idea what they want![]()
Not sure what I am missing...the date selection in Autofilter is not picking the actual date (VBA)
http://www.excelforum.com/excel-gene...ate-range.html
Can anybody find a formula approach to this?
http://www.excelforum.com/excel-form...ncatenate.html
Both are same.. can someone help to grab a formula approach..
http://www.excelforum.com/excel-form...-criteria.html
http://www.excelforum.com/excel-form...-criteria.html
http://www.excelforum.com/excel-prog...-text-box.html
Ran out of time
Can someone have a look at this, please. Lost on me.
http://www.excelforum.com/excel-prog...rten-data.html
Regards, TMS
Could use another opinion.
http://www.excelforum.com/excel-prog...r-filters.html
I guess I'm too tired to understand this today.. So can someone jump in: http://www.excelforum.com/excel-prog...-two-rows.html
ive gone as far as i can with this chart problem any takers
http://www.excelforum.com/excel-char...-the-week.html
This thread has suddenly entered an arena I know nothing about: http://www.excelforum.com/excel-char...curve-fit.html The OP indicates that he wants to be able to add an option to the chart trendline dialog to accomplish his task rather than do the work directly in the spreadsheet. Anyone who wants to dive into this one? Is it even possible to modify Excel's built-in dialogs?
Can't seem to get Vlookup up to work in the Userforms
http://www.excelforum.com/excel-prog...ml#post3944556
Isn't its time to create a new thread..
"Call in the Cavalry - 2015 onwards "
...pedantic note. 2015 is '2014 onwards'
I'll get me coat...![]()
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Oh ya, Ha!![]()
All who are interested should perhaps subscribe to the 2015 Cavalry thread started here:
http://www.excelforum.com/the-water-...5-onwards.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks