excel 2010

Hi Everyone, I have created some code, and what it should do is select row 5, starting in column F tot the last filled cell of that row, so for example F5:ZZ5 and change all values to "No". Next it prompts the user to enter a number, for example "20", it now puts 20 random values in the range...

Hey guys, I have this code (below) that looks in column C and searches for values that are greater than 0.01 and if found pastes them in column G as a list. to test I entered in two cells to have values that were greater than 0.01 Cell C5 and Cell C9 and in my results the code is entering cell...

Hello, I am working with a spreadsheet with numerous validated lists from named ranges; I'm good at the beyond-data-entry functions of Excel, but a novice a VBA. I've googled a ton, and I think I have the gist of how the code I'm looking for should work, but no idea on writing it or defining...

I have a macro that is supposed to Close the open Workbook, and shutdown Excel. It closes the Workbook OK, but does not shutdown Excel. The code is below, what is wrong? I am running Excel 2010, on Windows 10 Pro. Code for Savit Sub Savit() ' ' Savit Macro ' Saves and closes the workbook ' '...

I need to run (a variant of) this module a few hundred times. After a few times (2 to 5) I get an error "insufficient memory". Anybody any idea how to fix this? Sub testertje() Dim WBmodel As Workbook Dim WSscan As Worksheet Dim pad As String pad =...

Hi All Im getting a bit lost on what im trying to do here I have the named range value in Cell D5 and this range changes dependant on other dropdowns, which then creates a data validation list in a tabular from im building, but i want to build a summary table where the list of values in that...

I am using Microsoft Excel 2010; 32 bit I have a workbook query set up through Power Query that returns a table (24 columns, 12,000+ rows). It is a web connection to a DB2 (authentication required). I have it set up so that the first column is the modified date (date and time stamp). The table...

If I enter the following code into the ThisWorkbook object in a newly created Excel document: Sub Clean (ws as WorkSheet) MsgBox ws.Name End Sub Sub test() Clean (WorkSheets("Sheet2")) End Sub I get the error "Object doesn't support this property or method". What do I need to do...

Hello experts, this is my first post in this forum. I've searched a lot of posts over the last two days and just can't figure this out. Brief context of my problem: I built a Tableau report that uses Excel as datasource. The excel workbook is edited by a number of users and is stored in...

Dear All, I am using Excel 2010 and the spreadsheet I am working on contains 6,500 rows of data. I am currently using a filter to reduce the output to a certain product and I am using the =subtotal(9,C1:c6500) formula to create a subtotal, however, I would like to know if this formula or...

When I click the button that calls up the userform, the userform comes up, but none of the default values I have picked show. I am using Excel 2010. How do I fix my code? Sub NewTranslationRequest()'Fill Default Data OptionButton1 = True OptionButton2 = False OptionButton3 = False...

Hi All, I have a small excel problem that I need a little help with. I have a Spreadsheet that contains part of a postcode in column A to be exact the data is between A3 and A63 although there is potential for this to expand. The column contains either the first part of the postcode OL7...

Greetings Excel gurus. I have run into an issue that I cant seem to resolve and I know the answer is probably simple. I am using Excel 2010 I have a spreadsheet that was built to allow users to enter data, there are two columns in the table that need to either be locked or unlocked based on...

I have a spreadsheet that will be used as a template to enter data and then the sheet will be saved as a CSV file with a command button. Once it saves the file it come back to the template and asks if user wants to clear out the data. In order for this to happen and not lose the formulas the...

Hello, I want to use scenario manager for my calculations but i have too many scenarios(around 1000) with 4 variables. It takes time to write scenarios manually. Besides i may change the scenarios over time. Is there a way to upload scenarios from excel spreadsheet? Or is there another way to...

I created a project task spreadsheet that has a GANTT chart as a part of it using formulas and conditional formatting. It works rather well for tracking tasks, their completion %, task owner, etc. There are several "sections" that list tasks which fall under that classification. Every Tuesday I...

Hi I have a macro that works fine if it is in the workbook that is being used, but i want to be able to make it work in any active workbook by assigning the macro to the quick access toolbar, but i cant get a worksheet selection change event in a module in my personal xlsb. This is my code i...

Hey all - So I've written a Macro to pull in the body of an email from outlook into a worksheet, and I want to be able to allow others to use the macro as well without having to redefine the Outlook MAPI Folder that the email will be drawn from for each individual. Currently, I am using this...

Hi, Im yet to go on a VBA course, however Ive managed to find a VBA code to pdf a report in Excel 2010 and automatically send it via email. However, now the report is a bit more dynamic - the pivot table is linked from Access and Im using a 'Slicer' to individualise each report that is to be...

Hi everyone, I am using Excel 2010 and I would like to be able to colour a cell in relation to the risk status i.e. red, red/amber, amber/green, green and the shades in between each. I do not want to put any text in the cells, I would just like a way of being able to change the colour of the...