Problem with "Lastline" in VBA Excel 200
Solved/Closed
Scream77
-
Mar 11, 2010 at 03:39 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 06:07 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 06:07 PM
Related:
- Problem with "Lastline" in VBA Excel 200
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Vba case like - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 11, 2010 at 06:07 PM
Mar 11, 2010 at 06:07 PM
try this
Lastline = Cells(Rows.Count, "A").End(xlUp).Row
Range("B9:H9").Copy
Range("B9:B" & Lastline).Select
Selection.PasteSpecial xlPasteFormulas
Lastline = Cells(Rows.Count, "A").End(xlUp).Row
Range("B9:H9").Copy
Range("B9:B" & Lastline).Select
Selection.PasteSpecial xlPasteFormulas