-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
srown
-
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"...- Dtex20
- Thread
- Replies: 0
- Forum: Excel Questions
-
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...- Dtex20
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Unprotecting a sheet once a text box is selected
- Started by dpaton05
- Replies: 49
Can you unprotect a sheet once a text box is selected and then reprotect it again when it is unselected? I do not want to use active x text... -
OFFSET function with multiple table
- Started by xdenama
- Replies: 43
I have 100++ sheet (table) with same format with difference high (total row not fix, will change). How to combine all table (sheet) in one sheet... -
Question about Data Validation.
- Started by omairhe
- Replies: 24
Hello all, I find data validation to be a useful tool in excel 2019. In cell A2 if the value = A then allow both positive and negative integers... -
VLookup Or Other To Match Data.
- Started by fintail99
- Replies: 23
Hi there, I have data, as follows: Sheet1 A1: Name B1: 0.5 (this relates to total time, see Sheet2 below) C1: £25.00 (this relates to the total... -
Split a year range into one row per year
- Started by rameez788
- Replies: 21
Hi all, I am new on this forum. I have attached sample data, i need someone to help me convert the left side to how the data looks on the right... -
Combine 2 var into 1 string with & in between
- Started by bumbum2812
- Replies: 21
Hi Experts Please help me combine 2 var into 1 string with & in between. My data is from A1:A2 & i have below code to put in MsgBox...