Tejas Kore
Board Regular
- Joined
- Nov 2, 2017
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Hi,
I am facing issue while copying a column with blank cells in between filled cells.
Here I recorded one macro which looks like this -
Sub Test1()
'
' Test1 Macro
'Range("H1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("M1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
If you go by this function it will copydata till that cell after which first blank cell appears . Here I used Ctrl+Shift+(Down Arrow)
I am facing issue while copying a column with blank cells in between filled cells.
Here I recorded one macro which looks like this -
Sub Test1()
'
' Test1 Macro
'Range("H1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("M1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
If you go by this function it will copydata till that cell after which first blank cell appears . Here I used Ctrl+Shift+(Down Arrow)