Re: automatic removal of empty rows
thanks
Posts by mavgir
-
-
Hello,tell, please, it is possible to create such macro для removal empty rows?
-
hi, tell, please, how to clean the sign pilcrow ( ¶ ) in combobox?
but I have to hold a cell format = text 1
number 1 -
-
Re: Move data with Sheet1 to Sheet2 in the correct columns
no, he throws not so, it is necessary the last changed row
it is necessary that like it, but it doesn't work where to insert?
ReDim ar(1 To 10)
ar(1) = arr(i, 3)
ar(2) = arr(i, 4)
ar(3) = arr(i, 1)
ar(4) = ""
ar(5) = arr(i, 7)
ar(6) = arr(i, 10)
ar(7) = ""
ar(8) = arr(i,
ar(9) = ""
ar(10) = arr(i, 9) -
Re: Move data with Sheet1 to Sheet2 in the correct columns
not absolutely, data are duplicated
-
Re: Move data with Sheet1 to Sheet2 in the correct columns
If ar(4) = arr(i, 4) Then
ar(6) = arr(i, 2)
ar(7) = arr(i, 3)
ar(10) = arr(i, 6)
ar(11) = arr(i, 9)
ar(12) = arr(i, 11)
ar(13) = arr(i, 7)
End If
but writes error -
Hello, help, please to move data to the correct columns. At least one for an example as it is correct to do it
-
Hi, please, look whether it is possible to accelerate action of a macros?
-
Re: combine several books in one
Thank you
-
Hi, help me, please, to combine data from the books in one book, consecutive. (.Row + 1)
That is data of book Koroner, book Smith and book Solomonov (A2:Q) to move in book General