Search results

I have run into that issue on occasion and have found that some data has been inadvertently posted in columns where it vastly increases the worksheet size, or corrupts the file completely. Now I just run a quick erase macro to clear all the possible cells that I know shouldn't hold data and the...

Thank you for your help. I rewrote the macro and it now does what I want. I now want to take that information and extract the sales for each individual and paste them into each ones sheet. I have written the following attempt to do that but I'm running into an End If error. I have a number of If...

I am trying to write a Do Until loop and everything works alright except when it gets to "B1" it keeps running and then the loop destroys all the work. I am trying to figure out two things: 1: When does the Do test actually happen? 2: How do I end the loop if my current test isn't working? Do...

Dear Sir JB7, If I haven't said thank you it's because I have been fascinated with the files you sent -my apologies for such tardiness. With respect to the files I can only say WOW!! Clarin's spreadsheet has so much stuff in it I would love to know how to do I can't believe it. I have wanted to...

Hi! I haven't used this version of the software so I missed the little Upload a File - I have attached the file now. Basically I want to edit cell Q10 and do what would normally happen by keying in F2 Home Del because I want to get rid of the apostrophe that is making the formula I have in the...

'=+A19'=+A52'=+A85 '=+A30'=+A63'=+A96 '=+C8'=+C41'=+C74 '=+C19'=+C52'=+C85 '=+C30'=+C63'=+C96 '=+C8'=+C41'=+C74 '=+C19'=+C52'=+C85 '=+C30'=+C63 '=+C96 The above would be the contents of cells Q9 to S16 (each has a '=+X22 formula) and I would like to remove the apostrophes (which would change the...

Hi! I have a number of situations where the cell content is quite similar and I could really benefit by being able to replace one or two characters within the cells to use elsewhere on the sheet. Typically it will be something as simple as '=+A41 I simply want to remove the apostrophe and...

I have run into a number of different situations editing specific cells in a macro but I am stuck on removing characters from a one cell line. I get lists fairly often that would be terrifically useful to me if I could remove various characters from various cells. Typically I get a line...

There are three tick boxes that the user can put an x into on the worksheet or they can leave them blank. I had to test for three potentialities and that would be that the tick box cells could have an X or a 1 or be blank F112 is where the result of the tests kicks out numerically. If the number...

I am mystified. After receiving the response above which seemed to work I cannot recreate the situation and I have lost the spreadsheet that it worked in. I have a cell that is supposed to act as a switch. If it is blank I want to use one print rage - if it isn't I want to use another. I...

Thank you! I like sending pictures because like they say "they're worth a thousand words."

I was working on a spreadsheet where I ran into a problem that (I finally figured out) but I was originally intending to send in to the forum. I have snipping tool and had taken a snip of the sheet clearly showing the cell I was concerned with and the data it was misreading, but there is no...

Many thanks! You will be nominated to the sainthood.

Hi! I have been trying to create a macro that will recognize that if a cell contains a 3 the macro will print out one range and if it contains anything else it will print out another range. I had thought this would be comparatively simple but no matter what I do I get A1:J77 and cannot get...

I have a document I'd like to add check boxes to but even though there seems to be a size selector in the Properties key I still get a box that is micro sized and its the external outline that seems to get bigger. Is there any way to increase the size so the tick is bigger and more visible...

Many thanks

Thank You!

I managed to get it posted in HotFile https://hotfile.com/dl/197642716/8bee311/Sampleageing_(1).xlsm.html This took some doing because I can't add programs at work and when I got home I couldn't get in here because my password wouldn't work and it's my work address that gets the update. My...

I have a number of macros I use on a fairly regular basis so I decided to use the Ctrl + key option and put in some fast keys. I wasn't thinking and I had Ctrl+d set up. It wasn't until I used Ctrl+d where I normally do to copy the cell above and it sudden;y did something else. I went back to...

Hi Hui! I'm sorry I haven't gotten back to you yet. I am unable to download the programs you have suggested so I can send you the sample data. I will do it at home on the weekend and get it back to you.

I have created a worksheet that produces statements for my customers. It feeds off a sheet that is upgraded from our accounting package so I have to refresh the formulas that pick up the line detail each time I import data. That's no problem but many of the lines that are imported contain...

I have a label in cell A2 and a number in B2 If A2 says "George" and B2 says 3 I want to be able to have three lines on another sheet with George in A1, A2, and A3 Similarly five rows if B3 (or whatever row I have) has 5 It sounds easy but I can't figure out how to do it.

Thank you!!

I want to set up a custom header with a company name R & B - I know there is a simple way to do this and thought if I used a set of quotes "&" or '&' would work but they just seem to shorten my header.

I'm sorry I'm no macro expert - I thought the article Chandoo sent out made sense but I seem to be missing something. I printed his posting out on three pages and walked step by step through it. It was then I ran into the problem error 424 Object Required. I posted a query and you responded...