Saisaisai
06-28-2017, 10:45 AM
If I use the VBA recorder suppose I have numbers that start arbitrarily in any row in column A for any arbitrary length.
-I trun on relative reference then hit record
-I hit Crtl + home to start in A1
-Then I hit Ctrl+down arrow and then Ctrl+down again to get to the bottom of the list
-Then I hit the down arrow key
-Then I enter in = sign
-Then I hit Ctrl + up and again Ctrl + up to get to the top of the list
-Then I hit Ctrl +Shift +down and to highlight the entire column and finally hit enter
This works for one list but as soon as I start the list in another row and a different size the formula doesn't work
pleas help
-I trun on relative reference then hit record
-I hit Crtl + home to start in A1
-Then I hit Ctrl+down arrow and then Ctrl+down again to get to the bottom of the list
-Then I hit the down arrow key
-Then I enter in = sign
-Then I hit Ctrl + up and again Ctrl + up to get to the top of the list
-Then I hit Ctrl +Shift +down and to highlight the entire column and finally hit enter
This works for one list but as soon as I start the list in another row and a different size the formula doesn't work
pleas help