Insert Degree Symbol in Average Calculation
I have a list of temperatures that is 364 rows long and have an average calculation at the bottom. I am attempting to find a way to enter, if possible, the degree symbol ASCII 0176 in the line of temps as well as the overall average. When done in VBA/Macro using a script I copied, it changed the formatting of the filler color and number colors but did put the degree sign in. It expanded my average into an additional 9 digits to the right of the decimal point. I'm attempting to deal in whole degrees WITH the degree sign leaving my conditional formats in place alone. Any help??? Thanks, TRS111
Excel Table Size in Macro
Hi, I downloadexternal Excelinformation and run a macro I created for it. It works great. However, the external infoI downloadgrowsevery week with new rows and when I run the macro,the new rows dont get included in the table. This is part of my macro to turn it into a formatted table: ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$X$125"), , xlYes).Name ="Table1" So, it creates a table and formats it with 125 rows. Butnext week,there may be 130 rows, not 125 rows. Since the Macro only goes to row125, the table stops at row125 and misses the last 5 rows. Question: Other than setting the table size in the macro from"$A$1:$X$125" to something like "$A$1:$X$1200",how can you select all the rows (including the new 5 rows) automatically without making the table so large by using ("$A$1:$X$1200")? Thanks, Wayne.
Macro issue with email connectivity
so i have a macro that i send each day for work - it's on my excel spreadsheet. it's supposed to automatically send my pnl sheet to the designated people on email. it works fine on my home laptop, but here on this computer it doesn't work for some reason not sure if it's because there is an issue that the email is not linked somehow? or that maybe my antivirus is blocking -
Marco to create .CSV
This is one of my first macros so please be nice:). I have pieced it together through recording and Google searches. It performs as expected but the program/website used to import the file does not recognize the file type. If I open the file and select "save" and "yes" to keep using CSV format and then close the file and select "no" to save file, the program/website will import the file. I think this is the piece that is not saving the file correctly. I appreciate any input. Thanks.
Simple Text Searching Macro
My problem is simple in design, but I won't comment on the difficultyof execution. In summary, I need to match data from two columns of data with the corresponding data in a separate two columns of data. The data is just a text string, specifically the name of a company, and a location (city, state). Manually I accomplish this by looking at the raw data here: On the first line I see that it's Company AAA, located in Washington, D.C. I then turn to the other set of data: If company AAA is listed here AND the city for that particular company is as well, I delete the original row of data I started with. If not, I abandon the search for this first data set and move back to the raw data, and repeat for the next line. By way of another example, you will notice that Company C, in both Nashville and Memphis are in both data sets and therefore would be deleted from the first. I understand the basic idea of several loops with nested conditional statements but I'm far more interested in having someone produce this straightforward macro for me instead of spinning my wheels learning this specific language. Obviously, I would pay for this. Does someone think they can help?
