-
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.
a.endxlup.row
-
E
Excel for MAC is crashing
Hello All, I am trying to fix the following macro which I am trying to execute in MAC. It works/loops for sometime and then excel gets closed. My code below: Set wb = ActiveWorkbook Set ws = Sheet1 a = Sheet4.Cells(Rows.Count, "A").End(xlUp).Row If a > 1 Then For b = 2 To a c =...- excelpunk
- Thread
- a.endxlup.row excel set sheet1.cellsrows.count wbb
- Replies: 0
- Forum: Excel Questions
-
L
Refine a VBA script
Hi guys I have written a VBA script that is quite lengthy. I've written it taking bits and pieces of seen others post, and then amended for my requirement. To aid performance and save on memory/disk space, can anyone help me (using your expertise instead of my newbie knowledge and) refine the...- lloydie8
- Thread
- a.endxlup.row lastrow1 lastrow2 lastrow2.formula s1.cellsrows.count
- Replies: 0
- Forum: Excel Questions
-
D
Copy paste in VBA only copying last set of data
Here is my code I am simply trying to copy data from worksheets whose page name must initially be looked up (VLOOKUP). I have a total of 42 dropdown boxes that link to sheet names that are to be added to the list. I am fairly new to VBA and I can only get the last .copy to work. below is my...- DylanMa
- Thread
- a.endxlup.row range set wksdst.cellslastrow
- Replies: 2
- Forum: Excel Questions
