-
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.
multiple events
-
P
2 change events in one column
Hi, I have an excel file in which in one single column multiple change events are happening. For example on the basis of change in value in cell B9 some code needs to be run and then the basis of value in B10 some code needs to be run but I am not able to keep this 2 events separately. Can you...- punnu07
- Thread
- Replies: 2
- Forum: Excel Questions
-
P
Copy and Paste Multiple Cells
I could really use some assistance to complete this macro. So far, I have a code that will review the value of a cell and insert a row on a following sheet. Sub AddRows() Dim i As Long Dim j As Long Dim k As Long Dim l As Long For i = 1 To 200 If Sheets("S&S Build").Cells(i, 28) = 4 Then...- pgavin13
- Thread
- Replies: 14
- Forum: Excel Questions
-
V
More than one event in workbook object?
Hey guys, This may be a dumb question because I've been looking for an answer all over the internet and can't find the problem mentioned anywhere. I'm relatively new to Excel VBA though, and I'm trying to create two events for a single workbook. Is this possible? I have one workbook open...- vincent2722
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
loop through merged cells in a Column to get their addresses
- Replies: 46
I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas... -
Split a Column into 2, use a character limit that does not cut words in half.
- Replies: 31
Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The... -
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
Preventing duplicates
- Replies: 24
Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for... -
EXCEL SHEET auto enter Dates
- Replies: 23
Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...