-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
excel.range
-
J
How to Compare two list and add missing information from List A to List B
Looking for a little help. I need a way to compare a list on one sheet (A), Column A; with a list of values on another sheet (COMPARE), Column A. If the value is missing from the list on Sheet (COMPARE), it copies the value to the bottom of the list on Sheet (A) along with the values of the...- jirpel
- Thread
- compare dim excel.range list sheet
- Replies: 1
- Forum: Excel Questions
-
J
How to Compare two list and add missing information from List A to List B
Looking for a little help. I need a way to compare a list on one sheet (A), Column A; with a list of values on another sheet (COMPARE), Column A. If the value is missing from the list on Sheet (COMPARE), it copies the value to the bottom of the list on Sheet (A) along with the values of the...- jirpel
- Thread
- compare dim excel.range list sheet
- Replies: 4
- Forum: Excel Questions
-
R
Excel Sheet Visual Basics Question
I have my folders auto sorting on certain column like this: Sub Worksheet_Activate() rowcount = ActiveSheet.UsedRange.Rows.Count Range(Cells(9, 1), Cells(rowcount, 13)).Select Selection.Sort Key1:=Range("F9"), Order1:=xlAscending, _ Header:=xlNo, OrderCustom:=1...- RudeBoy
- Thread
- end excel.range rows skip sorting
- Replies: 0
- Forum: Excel Questions
-
Run Macro on click of cell in range target - Intersect/Target Clarification
Hi There, I have a question regarding the code below which is written on a worksheet. Firstly, does all code written on a worksheet have to be named "Worksheet_SelectionChange"? And what is "ByVal Target" mean? Lastly, the line "If Not Intersect(Target, CheckRange) Is Nothing Then" is not quite...- Prevost
- Thread
- checkrange) excel.range intersect(target macro auto run worksheet_selectionchange
- Replies: 1
- Forum: Excel Questions
