Search results

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

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

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

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

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

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.

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.

Hi! I got this suggestion the other day and am working on a large spreadsheet range A2:Q695 which I am using to reconcile various items against each other and the ability to highlight the row and column I am in would be terrific. I followed the directions very carefully but after all is...

I use the freeze cells function all the time and in my old version of Excel I could set them up and save the file and the next time I came into the spreadsheet the titles were properly frozen. Since I have had the new version (2010) this function doesn't seem to be saveable any more. Every time...

I have a spreadsheet which is set up with a line of sort keys across the top. Lately I have found that when I am trying to use the select button in the last three columns on the right I always have a text box popping up and yet my other columns seem to perform in their normal fashion. Can...

Sub Macro1() ' ' Macro1 Macro ' This is a great function on a spreadsheet but in a macro ' it wants to go all the way down to cell 65536 which sort of ' negates the whole point of a macro’s speed Range("A4").Select Selection.End(xlDown).Select Range("B5:B338").Select...

1: I import a data sheet that I need to edit before posting it to another worksheet. When I import the data I insert a column which serves as a line counter. The imported data is usually skewed so I need to sort it out and this is where my problems start. The range I usually have to sort...