excel 2010 macro issue

Hi all, I am developing a dashboard to convey a heap of information in the most visually appealing way possible and am having trouble with some VBA code. I am trying to write some code which will shift the formatting between a print view (which is mostly black and white) and a normal view...

Good Afternoon, I have created a set of code which works in Excel 2010 and 2007 to do the following: 1.) User fills in form as per questions. 2.) User is asked if they have completed other requirements. 3.) Form unlocks checkbox options so user can continue with form. I am now seeing issues...

I apologize for not being too Excel savvy but the debugger loads with the below line highlighted: FName = Mid(FullFilePath, InStrRev(FullFilePath, "\") + 1, 999) actually just the Mid function is highlighted. I am wonering if anyone has seen any of their functions breaking with the...

Hi All, I am using ADODB connection to query sheets in excel. There is one temporary sheet which holds some data while macro is running and this data is dynamic..But when I query this temp sheet i dont get anything..but if sheet is saved then i get data.. Its like i put data in temp sheet but...

We are in the process of switching from running Excel 2007 under Windows XP to running Excel 2010 under Windows 7. Most of my Excel reports are not having any issues. However, I have several macros that cause Excel to crash when they go to save the file. Through trial & error, I have found that...

Hello,<o:p></o:p> I am having a slight problem with an auto-sorting macro onan excel sheet. I have a sheet with aheader on row 2, and columns from A to Q, and the information on rows 3 to22. The issue is coming up from columnsB and C. I need the values in column Cto sort greatest to smallest...

I have a spreadsheet that uses a concatenated formula to copy values from column A to column B that looks like this: =CONCATENATE("(16)", " ", Master!A16) They have asked me to write a macro to move the value from column B to column B in another worksheet. Here is my Vb: Sub Macro1() ' '...

I have a large column of data sorted into sectors of varying lengths. I would like assistance in crafting the VBA formula(e) which determine into which percentile the individual datum lies. For example, <CODE>Sector Value Percentile A 1.024% ? A 3.027% ? A 4.487% top 33% B...

Hi all, I'm currently doing a set of macro codes which has quite a lot of same data starting with "FH" and "FB". Just wondering if there is any ways where I can just filtered out by "FH" and "FB" without typing the whole data out into my codes (in red) as shown below. Please advice. :) Thank...

ok So I have a workbook and it continues to grow but each sheet is copied from a master sheet, and then that day's data is entered. I have almost everything set to be perfect but now I need column J &K to sort automatically upon update of a number in J (which automatically updates). I need it to...

Hi Just wondering if some one could help me out. i have a workbook with multiple worksheets in it and every page has a droop down list of how many items are required. Then i have used conditional formating to display the desired results. But it is looking like having 50+ different rules on the...

I have a 2003 Excel xls file that I am trying to run in Excel 2010. I first saved the file as a xlsm and added the directory as trusted in Trust Center. I am getting an error code in the red. Note: If I change the PivotTableVersion to 12, it still gives me the same error. Code is below. Thank...

Hello. I am developing a .XLSM dashboard for a company in my PC (I'm a freelancer). I finished the dashboard and I've seen it running in different PCs, even in Excel 2011 (Mac). But when the administrator of the server put the file in a server location, open it (remotely) and try to interact...

Hey guys, I have this outrun VBA code that loops a string that places thousands of images in an excel spreadsheet. It starts out running pretty fast but as the images add up in the spreadsheet it eventually grinds to a halt. I need some help fixing the slow pace it runs at toward the end of the...

I finally got my first VBA Excel macro up and running, but am having issues when using the *.xltm file I created.When I open Excel and select File>New>My templates and select my created template (called Resource Report Workbook), everything works perfectly...I get a new workbook opened named...

Hi all, i have a small query if any one please help me how my excel 2003 macros will run in excel 2010 - i have tried in many ways but is not working . please help me if any one know the answer . please don't copy paste external links i cant understand that. regards arvind

Hi All, I have an excel workbook created in 2007, but now running in 2010. In the workbook I have a form Combo box with a macro assigned to it. When I click any value in the combo dropdown list the macro executes. In 2007 I could click the combo dropdown box and then press ESC to exit from...

Hi all! I have looked through a tun of threads about print macros, but none of them are quite what I'm looking for. First of all, I am using Excel 2010. I have a workbook that has roughly 150 worksheets in it with information for each of my employees. I am looking to set up a macro that will...

I'm baaacckk. In the processes of cleaning up my macro recorded code I have run into a problem. I have the formula in column G. I need to have just the values after the formula has been calculated but in the same column. Here is my code. What am I missing? Range("G2:G" & (Range("A" &...

New guy back again. I'm trying to clean up my macro I made using the recorder. This is the code and I get a Run-time error '1004': Application-defined or object-defined error. I don't know enough to know what the error is or how to fix it. For what it is worth the code is the very first...