2010

  1. O

    Selecting multiple cells in an active row and copying to the next sheet

    Help! Im using Excel 2010 and want to create a macro that allows me to cut the cells A:S and U in the current active row and paste in the same locations on the next page, at the bottom of a growing list. I would like formulas to be copied also. Alternatively, cut and paste the entire row, but...
  2. P

    Macro written on Excel 2010, breaking in 2007; researching the issue but would appreciate a quick response

    Hello Excel and VBAers, I wrote a macro that works great in 2010. A colleague needs to use it and it breaks on his 2007 workbook. I call a file that's 97-2003 format or ".xls", this works great in 2010, but when I try running the exact same macro on his 2007 excel, it breaks. It seems like it...
  3. P

    Excel 2010 - Copy workbook to another location & rename with existing workbook name but add date & time

    Hi - cant get this to work.. Firstly though I have put in the folder location as below to the desktop the workbook copy keeps only going to "my documents"?..also I want to add the date & time to the copied workbook to stop it over-riding previous copies - any ideas? Sub...
  4. R

    open last saved excel file in folder and subfolder / vba excel 2010

    Hello, I have been searching for many hours for a VBA-code in Excel for 2010 for the following. I want to open the last saved closed Excel-file that can be found in a folder and its subfolders. It has to open just one file in the folder or in one of its subfolders. It should find and open e.g...
  5. A

    Selecting a variable number of columns

    I have a value on one sheet that when I change it, I would like it to hide a number of columns on another sheet. This is what I have so far Private Sub Worksheet_Change(ByVal Target As Range) Dim i As Integer If Target.Address = "$C$34" Then i = Target.Value Sheets("Cost...
  6. A

    Excel 2010 64-bit VBA Macro stops executing for no reason

    Hi there, I have a really bizarre problem with a macro I've written which appears to simply stop executing at a certain point in the code. I am using a 64-bit install of Excel (part of Office Pro Plus edition). This is the code I've written: Sub prepBudget2013forFDM() Debug.Print...
  7. O

    Help with Copy/Paste Macro for Excel 2010

    Hello all Excel users! I'm gonna start by apologizing for my poor explanation, if anything is unclear, please let me know. I work at a hospital and I'm writing lots of patient data in excel, this process can be quite time consuming and I've been looking for a quicker solution. I'm quite new...
  8. J

    DAO360 in 2003 becomes what in 2010?

    I have an Excel 2003 spreadsheet which communicates with an Access 2003 database, which works in Windows XP / Office 2003, and I'm trying to get it to work in Windows 7 / Office 2010. This is out in production, so ideally I'd like to make no changes to either one of these files. The problem is...
  9. J

    DAO360.dll in 2003 becomes what in 2010?

    I have an Excel 2003 spreadsheet which communicates with an Access 2003 database, which works in WIndows XP / Office 2003, and I'm trying to get it to work in Windows 7 / Office 2010. This is out in production, so ideally I'd like to make no changes to either one of these files. The problems...
  10. E

    Interesting - Send gifts to members :)

    Hi everyone I would like to seek your help in doing a macro. I have four sheets: The first one is a list of all members and their score. Sheet 2 is populated as users fill a optin form on our website. They'll be registering for a free gift which will be sent to them on scoring more than 100...
  11. Dan DeHaven

    Using ADO as the connection for a ListObject

    Using Excel 2010 I want to set the connection of a ListObjects.QueryTable to and ADO source. Under MSDN's info on QueryTable.Connection property they say that "Alternatively, you may choose to access a data source directly by using the Microsoft ActiveX Data objects (ADO) library Instead" of...
  12. O

    Excel 2003 Macro not working in Excel 2010

    Hi all, i can´t get this code to work correctly in Excel 2010. It is used to make simple organization charts, by pasting a Autoshape circle and connecting it with a line to another circle, this works fine. The macro can also be used to remove the circle and line again by using the same...
  13. Gingertrees

    How the heck to use option buttons in 2010?!?

    In Microsoft's infinite wisdom of fixing something that wasn't broken, I no longer know how to add multiple groups of Option Buttons (Radio buttons) easily. In 2003: I would add an Option button, remove the stupid "Option Button 1" text caption, and copy/paste however many buttons I would...
  14. N

    Requiring Assistance with VBA Excel 2010 - Using Textboxes to fill cells relative to a ComboList's result

    Hopefully this isn't too difficult to explain what I'm looking to do. Pretty Much I am making an interface to deal with all the databasing of my construction jobs. This interface is on a separate Sheet from the database. My Goal is to create User Forms that will fill the relative database...
  15. H

    guidance for dynamic named range

    I'm reading the contexture web site regarding dynamic named ranges, and it refers to : insert | name | define , problem is this is for 2007, I have 2010 and I can't seem to locate similar options / commands, any suggestions where I can find these or guidance on how to in 2010
  16. O

    ActiveX Combo missing Slider, XL ver 2010

    I'm using Excel 2010. I'm also a first-time poster on this forum, so I may amend or post clarification, later, if needed. And I welcome comments on forum protocol or requirements. I use VBA code extensively in the application. There is a "trigger" (on the down arrow of the Combo) to a...
  17. A

    Excel 2010 importing time as 0

    I have several spreadsheets that import DB2 records that include a time column (hh:mm:ss). The spreadsheets work in Excel 2003 & 2007. In Excel 2010, the time entries appear valid on the MS Query page. They are all 00:00:00 when brought over to the Excel page. The column gets automatically...
  18. P

    Custom UI Error

    greetings, i just finished working on a custom toolbar within a workbook for excel 2010. however, when i tried to add multiple buttons and open the file, i got an error message saying: "Multiple custom UI parts were found in the file. Only one part is expected." Is there any way to fix...
  19. T

    Microsoft office for Mac. Excel 2010 has VB

    I just wanted to pass along that the version of Excel 2010 on my new Macbook pro has Visual Basic available.
  20. J

    VBA AutoFilter Using Wildcard not Working - Excel 2010

    Hello I've searched all over to and tried everything to get my code to filter a range of cells based on an input into a text box. I want the range to filter on every keystroke in the box and also want there to be a wildcard before and after the text box text. I can get the code to work fine if...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top