Search results

Hi Rich, Thanks so much for your reply, which tracked down my runaway shapes like a bloodhound on the scent of a large bowl of Pedigree Chum! In fact I couldn't fully understand the full routine - particularly the 'print' reference, so I remmed out all but the last line and then cycled through...

Good morning all, This should brighten up your morning. I've got myself in a bit of a fix. I've lost two shapes in a worksheet, and can't find them because they are formatted with no fill and no borders. There are a number of other shapes in the sheet which are formatted and so are visible...

Hi again, Gasman, That was my original method, however as I explained above, it took ages to copy the master template - I mean really ages. However by inserting a new sheet and then constructing the form with macro(s) on the newly inserted sheet it is ready more or less instantly. This is...

'Morning, :) And when I was using formulae in the spreadsheet that's what I did. And now that I'm building the spreadsheet with macros rather then directly on the sheet, this query was to find out how to do the same thing in VBA rather than having to type hundreds of lines of code. Anyway, I...

By the way, namliam, it is perhaps appropriate to mention that the '+2' is a result of referring to a previously defined list of items into two separate lists, with every alternate row going to one of two separate new lists, using 'copy and paste' to minimise the work involved. Did I explain...

Good morning namliam, Thanks for your comments. I think the answer to your first point, is that these lines are written in VBA rather than as formulae on a worksheet. The reason this is being run as a macro is that I previously created a form in a workbook - a 'master' - with a macro to...

Thanks so much, Gasman - works perfectly, and I even managed to understand it (eventually) and adapt it to the next column, with a different formula structure! Only 8 more columns to go.... :) Many thanks again, and a 'Thank You' duly awarded.

I need to write 40 lines of code in which only two cell references change in each line. Can I do a 'For Next Loop' for this instead, and if so how would this be constructed? The code I have is: With ActiveSheet .Range("A181").Formula = "=IF($AA$2<2,"""",A180+2)" .Range("A182").Formula =...

Wonderful -works perfectly for what I want to do. Thank you so much. :)

Good Morning all, Can someone please tell me if it possible to select a range of cells (which are to be cleared), the starting cell of which depends on whether or not a cell has a value in it? For example, if cell A56 is not populated then I would like VBA code to select range A56:T167. If...

Glad to have made your acquaintance Brian. Thanks again.

You know, Brian, I've been using Excel and VBE for perhaps 15 to 20 years now. During that time I like to think that I've built up a reasonable knowledge of both. Not like yours of course, but enough for my needs. However due probably to a) working under time constraints and b) laziness, I have...

Hi Brian, Hope you had a good weekend. Pleased to say that the code is working fine. Exactly what I wanted. I do have one problem though which I didn't foresee and for which you may have some ideas. If the item to be deleted is the last one on the infamous list it won't delete, because it...

ALso for Mods attention, please Good morning Brian. I can see that an apology is in order. I have no idea why I started calling you John, and can only quote your comment - "I'm getting careless in my old age, I do apologise". I think perhaps that the change of name may have been triggered...

By the way, John, I note your code example. Thank you. I'm too tired to do anything about it tonight and I'm off to bed soon, but I shall be working on it tomorrow. TVM N.

A very good evening to you. :) "But I don't understand what it is doing, if you know the range why do you have to find it?" I know one range - the destination. I don't know the source range - the last (in fact two last) rows in the list. I have a list to which lines are added at the bottom by...

Got it. Done & dusted. Sorted. Yes. Got it John! :) As so often the case, a simple error on my part. When I changed from merged cells, to 'centre across selection', I failed take into account that this had the consequence of making the last cell in column Y an empty cell. So when your code...

Thank you very much for taking the trouble, Vassago. It keeps asking me to Log In,(edit: when I try to post) (and rejecting my attempts to do so) although I clearly am already logged in. John - how on earth can it be that when I run that code in a clean workbook it does exactly as I want. It's...

OOOOOpps! Sorry! And my apologies to the Moderators for the double post. I thought I had lost the previous one, so re-did it, only to find it had gone (although unfinished). Incidentally, Brian, I to am having trouble not only posting to this thread, but also in logging in to the forum. The...

'Only' 10 miles, eh? Well done! Workbook(Nomadscot).Delete Retiredbook(Nomadscot).Select Range("Home:Car").Select On Error GoTo Nearest Pub :) I do love the canals though. Had a narrowboat once, and spent many happy times cruising around England. As to the code, I don't know how - or if - I...