Call in the Cavalry - 2013

Hi,

Interesting. Is this even possible without VBA? Wouldn't have thought so - maybe with, then?

http://www.excelforum.com/excel-new-...t-another.html

Cheers

Does this OP have a hardware problem or is this something that may be happening with the forum and his IP address?

http://www.excelforum.com/excel-gene...cel-forum.html

Anyone that could provide a real vba code here?

http://www.excelforum.com/excel-prog...ive-names.html

I think this post is going to require some "know how". I know nothing about Mozillas object model and the OP has already bumped this.

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

@Solus: thanks for the feedback. I don't think that Thunderbird is VBA enabled and I Googled it and didn't get anything that would change my opinion. As I said, I'm happy to stand corrected if anyone knows better and can provide an example.

Regards, TMS

This thread keeps bumping up against errors due to incorrect scope of variables. I'm not good at working with module level variables, since I define my variables almost exclusively at the procedure level. I've already pointed him to Chip Pearson's discussion about variable scope. I'm wondering if it would be helpful for someone who is comfortable defining and using module level variables to come in and help explain the difference between procedure level scope and module level scope, because it just seems like he is constantly defining variables at the procedure level and then expecting them to still have value outside of that procedure.

http://www.excelforum.com/excel-prog...trix-code.html

I think I'm losing this patient...lol
Any VBA programmers willing to take a shot at this?
http://www.excelforum.com/excel-form...ml#post3480329

I have most of what the OP wants, but cant figure out how to add new names to the master, from each month sheet. Any suggestions?

http://www.excelforum.com/excel-form...ets-in-it.html

I am not sure if this is possible with out some VBA. I am not sure how to attack this issue on that basis.

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

@ alansidman,

I shall have you reported for animal cruelty! Also, I usually tackle a problem, since "attack" is not always the best approach.

Best Regards

@Winon
In the US, football, or as you refer to it as gridiron, a tackle can be more vicious than an attack. Thanks for tackling and providing a goal winning solution.

@ alansidman,

You are welcome. Glad I could help.

Thank you for adding to my Reputation.

Regards

I don't have an answer for this OP. Do you? Wants to know what happens when he runs code in a shared workbook. Will it affect users who have the workbook open?

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

http://www.excelforum.com/excel-prog...ta-points.html
I proposed a non-VBA solution that I thought was pretty easy and straightforward to implement, but the OP seems to think a VBA solution will be "easier" or "better". Since it isn't the kind of VBA programming I'm very good at, maybe someone else can jump in and help him out.

mac any one? 2011 macro recording anyone got 2011 which than can try?
http://www.excelforum.com/excel-gene...-going-on.html

Would love to help, yudlugar, but I'm as confused as you on this one!

Doesn't help that that has to be one of the most inappropriately-designed spreadsheet set-ups I've seen in a long time...

Anyone want to have a look at this one? I have offered VBA code to do what the user wants, and it works on both Mac and PC that I have tested, but it's not working for the OP?

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

- Moo

Biting of more than I can chew.... again.
http://www.excelforum.com/excel-form...d-average.html

I think it's a really interesting problem, some sort of recursive lookup average thing. Shouldn't be to hard for real formula guys. I love to see the solution for this. Daddylonglegs? Tigeravatar? PeteUK?

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

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

I think the OP is in need for a VBA solution where the main sheet needs be to split in 90 sheets.

http://www.excelforum.com/excel-gene...-and-link.html

Thanks!

A query about financials that's gone untouched for a couple months, any takers?

Anyone have any words of wisdom on this thread:

Excel will not print more than the first 5 sheets when I tell it to print all sheets!


I'm all out of ideas.

Thanks, TMS

I've tried various solutions but to no avail. I, too get the 1004 runtime error. Your thoughts on this OP issue

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

Seems that there is a disconnect that doesn't allow excel to paste if the immediate preceding action isn't copy.

Very strange.

Maybe:

Please Login or Register  to view this content.

I don't think you CAN paste or paste special unless you have just copied something. If you were to copy a cell and then type something in another cell you wouldn't be able to paste the cell you first thought of.


Regards, TMS

Trevor,
That is what I was attempting and the link to Mr E was suggesting. But a Runtime 1004 error. I think you are on target about the copy and then paste having to be in either VBA or manual but not both. Maybe someone else has a better solution. There is always the keyboard shortcut

Alt + E S F and enter.

Alan: you can copy manually and paste using the macro shown ... but the one must follow the other, as it would if you did both manually or both in code.

Trevor, as I noted in the OPs thread, it works if you assign a keyboard short cut, but fails when run from the Macro menu. Alt + F8. I find that curious.

Alan: I think it may be because, when you click on the Macro icon you effectively deselect the cell ... so there's nothing to paste (again)

Anyone want to have a go at a VBA solution for this?

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

Thanks a lot

http://www.excelforum.com/excel-prog...ete-row-2.html

This is a case of scope creep. I won't have time this weekend to sort through this. If you have the time and inclination, give it a shot. Thanks.

Retorical question: As an aside, why do OP's think it is easier to give an example that is not the whole picture and then ask to change when the solution works for the example given but not the real situation.

Alan

@ Alan - who can decipher such a mindset??

I am having trouble understanding (translating?) what this OP wants. Can someone else take a look and see if you can make it out?

http://www.excelforum.com/excel-gene...ay-change.html

Originally Posted by FDibbins

I am having trouble understanding (translating?) what this OP wants. Can someone else take a look and see if you can make it out?

http://www.excelforum.com/excel-gene...ay-change.html

I'm on it... I can see what he's trying to do

Originally Posted by OllyXLS

I'm on it... I can see what he's trying to do

.

Glad you can Maybe I'm just tired - time for bed lol

I am out of answers for this issue. Lotus 1-2-3 wk1 files to Excel 2007.

http://www.excelforum.com/access-tab...-ms-excel.html

Anyone help with this one? Scope creep, as ever...!

Having solved the "copying cells including formatting" question, they now reveal they want to copy cells with formatting to a userform spreadsheet control.

http://www.excelforum.com/excel-prog...ml#post3508421

I have no idea about userform spreadsheet controls...

Can someone check this VBA printing: http://www.excelforum.com/excel-prog...-printing.html

Here the OP is looking to distribute an amount to many persons equally with two decimals to everyone without missing even a single paise (Cent) which should be distributed to everyone equally...

Any suggestions?

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

http://www.excelforum.com/excel-char...ml#post3509924

This one is curious. Apparently at some point, her chart decided to divide the data points by an extra 100 before plotting. I can see no reason for Excel to do this. Is there some obscure option or toggle (or dare I say it, bug) somewhere that causes Excel to divide percentages by an extra 100?

Protected View setting missing in OP's Excel (2007) and due to this OP not able to edit the files which opens in Protected View Mode.

Any suggestions??

http://www.excelforum.com/excel-gene...b-missing.html

I started a solution on this thread: http://www.excelforum.com/excel-prog...t-results.html

However, I didn't realize he was on mac. I don't have access to Excel for Mac and may not be able to provide a solution.

Can someone have a look here http://www.excelforum.com/excel-prog...mproduct.html?

I can't figure out what the OP's having problems with and why they want/need to use code.

I love the way the OP shown the expected result in the sample file really amazing

But I don't get any Idea for giving solution

Any suggestions??

http://www.excelforum.com/excel-form...ed-values.html

Does anyone has the time to take a look at this?

http://www.excelforum.com/excel-gene...ml#post3516033

Anyone got ideas for this OP for changing links to external files?

OP is trying to access an ADODB table with Excel and needs someone with a better understanding than I can offer (http://www.excelforum.com/excel-prog...or-1004-a.html).

Happy holidays.

abousetta

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

Drawing a blank

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

Part two of the OP thread possibly needs a vba script ? As I am vba stupid, that counts me out.

http://www.excelforum.com/excel-gene...ml#post3523723

Having trouble removing #Value errors :/

http://www.excelforum.com/excel-form...in-column.html

time for a 2014 onwards?

Sure, will do the needful.

Hurray post moved.

The new thread

Everyone be sure to get subscribed.

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