I have this script that past all values into a column in my MSHFlexgrid
Dim lRows As Long
Dim sText As String
sText = Clipboard.GetText
lRows = UBound(Split(sText, vbCr)) + 1
.Rows = .FixedRows + lRows
.Row = .FixedRows
.Col = .FixedCols '(or whatever value you like)
.RowSel = .Rows - 1
.Clip = Replace(sText, vbLf, "")
But this is if i copy value from a same column.
I would like to now copy into clipboard data from 2 columns and it would paste it into 2 columns in my MSHFlexgrid.
if i copy this below from my excel file:
When i paste into my MSHFlexgrid it will paste it into 2 columns:
How can i do that?