variable cells

Hi, looking for some help with this Solver VBA. Here's what I'm trying to do: 1) "Set Objective" is equal to the value in cell D3 2) "Value of" is equal to the value in cell D1 3) "By Changing Variable Cells" - this range in column D (starts on D4) changes according to the number of rows in...

Private Sub TextBox3_Change() TextBox5.value = Application.WorksheetFunction.IfError(Worksheets("Codes"), Application.WorksheetFunction.Index(Worksheets("Codes").Range("b2:zz29"), Application.WorksheetFunction.Match(Worksheets("Codes"), "L50", ("a2:a29"), 0...

Hi there, I’m using the solver add-in for excel, I’m using it to optimize problem. However I’m running my head against a wall. I must say I’m no pro at excel, so it might be a simple question, but I’ve searched the net for hours now, so I hope you can help me. The variables set in ByChange...

Dim HINTE As String: HINTE = Sheets("Temp").Range("T18").Value Dim Pathf As String: Pathf = Sheets("Temp").Range("T15").Value ChDir _ "filep" ActiveWorkbook.SaveAs Filename:= _ "Pathf " & HINTE& ".xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled...

Sub FormatReprot() Dim AC As String: AC = Sheets("main").Range("H17").Value ActiveWorkbook.SaveAs Filename:= _ "C:\Dept\Report\NC.xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False I am trying to make a variable for the file name. However I instead...

Hi Everyone, I'm building a random name generator for a series of charity prize draws and I'm having a few problems perfecting my code. Basically, I have some VBA code that will search through a single column of names (column a) then select a name at random from the list before displaying the...

I have a report that is ran once a month and each sheet in the report has a variable number of rows each month. I have used the macro recorder to subtotal each sheet, but on sheets with more rows, the code does not include them in subtotal. I have tried using an offset but that didn't work...

Hello, I'm trying to use the following code to evaluate an array formula across a range of cells: Sub EvaluateTest() ActiveSheet.Range("D2:G2").Value =...

Hi there, I am preparing a budgeting document and for one of the items I require the value in a cell to change depending on what day of the month it is: For example, if the budget for something is £3500, I want cell J13 to show: 3500/4 if the current date is the 1st-7th of the month...

Hi, I'm very new to VBA and cannot get my code formatted properly to do what I want! I have this code below that almost works the way I want it to: ActiveSheet.Shapes.AddChart.Select Application.ActiveChart.Parent.Name = "StackedChart-PBS" ActiveChart.ChartType = xlColumnStacked100...

Hi, I have a cell that is dependent on multiple randomly generate cells and I need help on how to graph the output of this single cell as it generates a new value every time I refresh the spreadsheet. If not, is there a way i can get its value each time it is refreshed (life for n=100...

Hi, To start off, my question is very similar to the one at this location: http://www.mrexcel.com/forum/excel-questions/553169-concatenate-row-variable-number-columns.html This is the provided solution that I've been trying to use: Sub ConCatFromColumnC() Dim X As Long, LastRow As Long...