basic

Hello all, I am trying to open the VB Editor via the following macro which is associated to a button on a worksheet but I get the runtime error: 5 invalid procedure call or argument. CommandBars.ExecuteMso "Visual Basic" Using excel 2010 .. Am I doing something wrong ? or is this a known...

I've been tasked with a project that requires something more robust and secure than Excel macros. In the distant past, I wrote projects like this using Visual Basic. Since Visual Basic has gone the way of the Pony Express, it's not an option. I was thinking about using Visual Studio, but...

Dear All, I need your urgent help in the following case: Here I have a sales sheet and I rename it according to each sales man. I need a VBA code to copy the sales sheet and renaming it according to the sales men name listed in the names column in the basic sheet as attached. so, I need to...

I'm not sure if this is the correct forum to ask this question or if I should have posted it in the VBA forum but here goes... <tbody> Product Name: Product Type 1: Product Type 2: Product Version 1: Product Version 2: Product Version 3: Product Version 4: Alpha Electronics Free Trial...

This may be more of a math 101 question than an Excel question but I would be grateful for some help in any case. Here is a simplified example of the problem: Say you have 12 widgets to divide up amongst 3 people and each one is non divisible (has to be whole numbers). The distribution...

Hello, I am super super new to VBA. My boss wanted me add a macro to a file where certain tabs are selected and create a PDF. Looked it up and I'm good there.. Now I need help just saving the file as the excel file name (excluding the excel ending)... This is what I'm working with. Sub...

I have just got a new version of excel and the cells property in VBA no longer works and I am shown the following error message. "Wrong number of arguments or invalid property assignment". This happens even when writing the simplest code. Are there settings that need to be changed?

Hi I'm working on some code in VBA in Excel 2010 and I'm running into a problem with preexisting code in the spreadsheet. My code reads in data from another workbook and posts the value in a certain cell, which works fine. However, there is code that is already there which causes an infinite...

Hi, I never really use excel, nor am I any good at it so this question may be seem stupid to many of you. Basically for a school project, I had to make a questionnaire and retrieve data and then plot it in excel, I'm trying to find out if internet speeds at a student's house affects how much...

Every time this macro is being used, the data comes from a different column but always on the same rows. I set FY13column to the user selected column but I can't figure out how to copy specific cells from within that column. Here is what I have that is not working: Set FY13column =...

Hi all, I have inherited this spreadsheet. On sheet 1 i can create times from B11 down eg 08:45 08:49 etc. The problem is i can have all the time stored on the data sheet but when i recall the times to show on sheet 1 it stops at cell B60. I have looked at the code and changed anything that had...

Each month we receive an updated budget which includes info for every month of the budget year. I want the user to be able to select the column (which relates to a month) that they want to use for the analysis. I will use the data in this column only for analysis. How can I do that? Thank you!

Hey everyone, I am super new to vba and am trying to get started to help speed things along with some study work. Firstly I am trying to create a macro that runs based on the value of a cell, and I need that macro to copy and paste data at the start of a loop. I have made the copy/paste macro...

I am writing a Macro that essentially makes a copy of the spreadsheet I am working on, removes all the macros in the background, and then saves it to a specific folder. The entire macro works perfectly on excell 2003, but in 2007 and 2010 there is an error in the section below. Does anyone have...

I am relatively new to using Access and I have been asked to put together a database for allocating keys at our school. Every member of staff has certain keys allocated to them based on their role. There are also some keys which open multiple rooms. So for example a teacher will need a classroom...

I have a simple spreadsheet and I want it to create a web query based on a list of URLs I list. In my sheet I list the URLs one every 3 rows (because the web query table it pulls back is 3 rows). So currently the loop is working, but it's pulling the same URL back rather than changing so...

Ok i have a program that goes to a different workbook and copies information. When i try to go back to the original workbook to paste the information, it says that it is out of range... can someone help me fix this? Code: Application.Goto Workbooks(Page).Sheets(Page).Range(CurrentCell) Goes...

hey guys im a newby just started programing, i have a basic spreadsheet with following fields: date time make model heres my ? i just want to sum all the cells with the same month, so far i have negative results.... can you guys bail me out? thanks in advance