I am very new to excel VBA. I have learned the basics of VBA programing language. Could you please anyone help me in this.
Assuming I have numbers in F9 to F208996 and G9 to G330571 etc.
How do I capture these numbers and convert it into separate nodepad files. i.e. I mean to say, F column datas in one textpad and G column datas in another textpad etc.
In figure below, I need to capture the bold numbers. The columns to be converted to each notepad are F,G,H,I always. The row to be converted to notepad starts always from 9th row till lot of numbers
I have made a rough code. But not sure how to write loop.
Sub Export()
Dim lastrow As Long
Dim lastcolumn As Long
Dim i As Integer, j As Integer
lastrow = Cells(1, "A").End(xlDown).Row
lastcolumn = activesheets.Cells(1, Column.Count).End(xlToLeft).Column
For i = 1 To lastrow
For j = 1 To lastcolumn
Next j
Next i
End Sub
Assuming I have numbers in F9 to F208996 and G9 to G330571 etc.
How do I capture these numbers and convert it into separate nodepad files. i.e. I mean to say, F column datas in one textpad and G column datas in another textpad etc.
In figure below, I need to capture the bold numbers. The columns to be converted to each notepad are F,G,H,I always. The row to be converted to notepad starts always from 9th row till lot of numbers
I have made a rough code. But not sure how to write loop.
Sub Export()
Dim lastrow As Long
Dim lastcolumn As Long
Dim i As Integer, j As Integer
lastrow = Cells(1, "A").End(xlDown).Row
lastcolumn = activesheets.Cells(1, Column.Count).End(xlToLeft).Column
For i = 1 To lastrow
For j = 1 To lastcolumn
Next j
Next i
End Sub
