constant

Hey there. I was wondering what the formula would be to create a dynamic range for a vlookup. The columns will remain constant, however the number of accounts will vary depending on the client. Thanks.

Hi Got a spreadsheet whereby row one contains important info: B1 is a constant code (501107), D1 is a constant code (171205) and F1 is a number starting at 0001. H1 contains a number that i type in. What needs to happen with this spreadsheet is, A2 needs to have B1&D1&F1 and it needs to carry...

Hello, I am looking VBA solution for specific task look up in row constant occurrences Data got in cells C5:P22, "1" is filled with red colour and white fonts, "X" is filled with dark green colour and white fonts, "2" is filled with blue colour and white fonts, Results shown in R6 AF22...

I want to convert variable "COLUMNS" as an Integer from the current classification of "CONSTANT." When I change Const COLUMNS to Dim COLUMNS as Integer, I am getting an error in [Dim RN(1 To COLUMNS) As Range] statement. It says constant expression required. How can this be resolved? Basically I...

I have a constant which I have tried to incorporate in my VBA code, but get subscript out of range Const Z As String = "BR1" nb.Sheets(1).Copy After:=Workbooks("& Z & Sales for northern region.xlsm").Sheets(1) It would be appreciated if someone could correct my code

I am trying to create a dropdown validation list on a sheet cell (not a form) using a function rather than a constant. I am doing this because the validation will be repeated on the same sheet for various columns, so rather than create 20+ Names, I thought I might be able to write a function...

Hey gang, I've run into an issue which would be easily solved with a #include of a .H file in C, but which I can't figure out how to do in VBA. Here's what I have. Script.XLSM Microsoft Excel Objects Sheet1 -> Contains a key macro to be copied into the Output.XLSM file on Sheet1...

Hello everybody, The excel must obtain the max value of a list of values, the range of values where it looks change depending on a constant. Exercise: a list of 30 random values in column A; on C1 a "constant" like 3, 5, 10, 15. On column B the MAX value of 3 (A1:A3), 5 (A1:A5), 10 (A1:A10)...

Hi Everyone, As you can tell by my username, I am very new to Excel VBA. I just started really utilizing it when I first realized that I can record a macro; however, as I continued it, realized what a powerful tool it can be for my work place when utilizing various data sheets. So far, many of...

I have set up a formula, =IF(T74="1/2Dry Stack",0.1,IF(T74="DryMortar Joint",-0.1,0)) , Linked to a drop down list on another sheet. How can I keep the value of the formula after making another selection on the list? i.e: if "dry sand" is selected on the drop down list, add 0.1 to total. then...

I am stuck and would appreciate any help that can assist me. I have an access database in whcih I upload data from different excel spreadsheets. In access the user clicks a button which a browsing window opens and they select the file they want to upload. The code then continues the upload...

Hello All! My deepest apologies if this has already been asked, as I am sure it has, but I am at work and do not have the time to hunt in the past threads. I am not very Excel savvy as I am more accustomed to film work, that said, I am doing some data entry and want to make my job a touch...

Hi All, I've declared the below variable as follows:- Global Const FilePathName As String = "X:\Sales\Tools\Available Distribution Tool\Company" I've tried to replace multiple file paths with the above along with the rest of the file path, but when you step through the code it doesn't seem to...

I have declared the constants below. Const TNTFuelAdd = 0.1 Const UPSFuelAdd = 0.16 Const RHENUSFuelAdd = 0.15 I also have the Variable ‘Transporter’. In a case the ‘Transporter’ variable has the value “TNT”. Now, I want to get the value of the constant TNTFuelAdd. I tried something...

Hey everyone. I'm having an issue using the pull/copy (dragging by the corner) for a pattern that skips columns from another sheet. Example (This is my formula for the first 5 rows, but I need to copy them down keeping the pattern going until 340) NPC'!$B$7 NPC'!$E$7 NPC'!$H$7 NPC'!$K$7...

Hello, I want to do a small function in excel that will permit the user to retrieve information stored in a VBA module. I cannot find a function in VBA that will make VBA understand that this is a variable. Here is my example: Const Key199309 =20 Const Key199310 =25 Const Key199311 =30...

Hello, I am trying to put multiple values into a single cell. I have looked into Array Constants but I may need some additional help with implementing the solution. I am working on Windows 7 Excel 2007. Let me start out with what I am trying to accomplish, and perhaps there is a better way to...

I'm working on an add-in that will have a user-form to make changes to a complex workbook. The add-in changes workbook "Audit Form.xls". How can I set this file name as a global constant in my add-in, so that I can just change this file name once in the add-in? I'm looking for something like...

Hi there, I have a spreadsheet with many rows and columns with lines that look like this: .........A...............B...............C...............D...............E .=Data!D28..=Data!E28..=Data!F28..=Data!R28..=Data!Q28 .=Data!D32..=Data!E32..=Data!F32..=Data!R32..=Data!Q32...