Dear Sir,
Plesae explain the for my information.
Range(a2:a15).Cells(K, 1) out would be like
ABDE.continue
but how it come
AABCCDDDEEFHHHIIJKLLMN
Please explain.
It working very fine as per my desire output
On Wed, Aug 28, 2013 at 10:53 AM, Prafull Jadhav
Firstly try your self to run one by one line using F8(function key)
Range(a2:a15).Cells(K, 1)
cells(k,1) - K count no of active cells in row
K value remains same till K count = count no of active cells in row
and its hold range(a2:a15)'s value
.
Enjoy
Team XLS
Got it Sir. Thanks a lot.
On 29-Aug-2013 9:56 AM, xlstime xlst...@gmail.com wrote:
Firstly try your self to run one by one line using F8(function key)
Range(a2:a15).Cells(K, 1)
cells(k,1) - K count no of active cells in row
K value remains same till K count = count no of active cells in
Dear All,
Very Good Morning ,
I have made macro but i am able to extract output in only one column but i
want it in 2 column .
Please help me in this regards,
Thanks in Advance.
Regards,
Prafull
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
PFB
Sub amit()
For K = 1 To Range(B2:X15).EntireRow.Count
For P = 1 To Range(B2:X15).EntireColumn.Count
Range(AA500).End(xlUp).Offset(1, 0).Value = Range(B2:X15).Cells(K, P)
Range(AA500).End(xlUp).Offset(0, -1).Value = Range(a2:a15).Cells(K, 1)
Next
Next
End Sub
.
Dear Sir,
Range(a2:a15).Cells(K, 1) out would be like
ABDE.continue
but how it come
AABCCDDDEEFHHHIIJKLLMN
Please explain.
It working very fine as per my desire output
On Wed, Aug 28, 2013 at 10:34 AM, xlstime xlst...@gmail.com wrote:
PFB
Sub amit()
For K =