Mirroring Range of Cells in Between Sheets

Issue Sheet1 Private Sub Worksheet_change(ByVal Target As Range) If Not Intersect(Target, Range("B93")) Is Nothing Then If Target = Range("B93") Then Sheets("Sheet2").Range("A1").Value = Target.Value End If End If End Sub Sheet2 Private Sub Worksheet_change(ByVal Target As Range) If Not Intersect(Target, Range("A1"))

Continue reading

VBA paste range

Issue I would like to copy a range and paste it into another spreadsheet. The following code below gets the copies, but does not paste: Sub Normalize() Dim Ticker As Range Sheets("Sheet1").Activate Set Ticker = Range(Cells(2, 1), Cells(65, 1)) Ticker.Copy

Continue reading

Select range in a particular sheet in excel vba

Issue I have a question about selecting a range in a particular sheet using excel vba. I don’t know why the following is not working: Thisworkbook.Sheets(“N&A”).Range(“B4:F16”).select However this works: Thisworkbook.Sheets(“N&A”).Activate ActiveSheet.Range(“B4:F16″).Select The VBA code is programmed on “N&A” sheet. Could

Continue reading

VBA MIN and MAX function always returning 0

Issue Hello I am trying to get the MIN and MAX values from the array and it always returns "0" despite anything. My code: Dim MachineCapacitySmallestArray() As Variant MachineCapacitySmallestArray = thisworkbook.worksheets(1).range("C25:D25") SmallestCapacity = Application.Min(MachineCapacitySmallestArray) in range I have natural numbers

Continue reading