Hi everyone!
I have a sheet with thousand of records and I have to run a specific function on one of the columns. The latter contains a large number of duplicates. I set up a new function with VB, but I cannot run it on all the data due to the required computational effort. Therefore I thought...
Hello I am trying to make a "Customize your new computer" spread sheet. I want the user to be able to select hardware upgrades from a drop down list which will automatically be added or subtracted from the total price of the computer at the bottom. I understand how to make the drop down list but...
I understand how to create an array within a routine:
CurOptions = Array("M1", "M3", "M3 DSR", "L1", "L2", "CSA")
But I need the array to be public as the array can hold one of 6 different sets of values so I will declare the array to be only used within the module as:
Dim CurOptions(30)...
Hi all,
I have several macros in a personal folder that all need to reference the same variables located in a single file. So I declared these variables as public. But I don't know the syntax for assigning a cell value to these. Something like: Public Price as Double. And then: Price =...
I am attempting to run the following line of code:
ActiveSheet.Range("AI18").Value = ActiveSheet.Range("A2").TextThe only catch is that both "AI18" and "A2" are hidden cells. When I run this code the values don't translate unless the reference cells are not hidden. Is there a workaround to...
Sorry that my first post should be so obvious, but I've tried searching the forum and can't find exactly what I'm looking for. Here goes:
I'm working in Excel 2007 and have a cell with a defined name, that I use elsewhere in a formula. All I want to be able to do is to have a YES/NO drop down...
I have the following data going across columns:
16 15 14 13 12 11 10
I want to use a function or statement that will pick out the second highest value (15) and assign a value of one in a cell. I need to do this for several rows. I used an If/And statement to pick out the highest and...
HI, I have the code I'm using now which works but was wondering if someone can help me condense it to do the same thing: THANKS!
Sub Modify_Instr_Tab()
Dim ws As Worksheet
'Assigns a due date to cell D10
Worksheets("Instructions").Range("D10").Select
ActiveCell.Formula = "5/28/2010"...
Hello,
I am in sheet5.cells(737,1) and i need to have in that cell the value of sheet1.cells(3,2).
I would like to use a formula, not a macro.
Any suggestions?
Thanks
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.