Recent content by Mortadella

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...