1. D

    Dynamic Price Box linked to ComboBox selection

    Private Sub MachineOptionsBox_Change() Dim priceCell As Range Dim imprCell As Range Dim selcItem As Long Dim sRowN As Integer Dim sCol As Integer Dim ws As Worksheet Set ws = Sheets("*Sheet Name*") sRowN = 0 For Each priceCell In ws.Range("C1:C5000") If priceCell.Value = "Agents View"...
  2. D

    Trying to paste range object that gets passed as parameter

    Hi guys, I didn't know quite what to title the thread. I have this function i pass ranges through, which copies the range and should paste it on a certain range on the spreadsheet. I'm having trouble with the .paste, section of the function. I define the ranges before passing through the...

Some videos you may like

This Week's Hot Topics