|
|
 |
|
| found 979826 articles for 0.537 sec |
  |
Author: Andreas Eibach
Date: May 13, 2010 20:04
... Kopieren() Dim LRow As Long With Sheets("quelle") LRow = .Cells(Rows.Count, 1).End(xlUp).Row .Range(.Cells(1, 1), .Cells(LRow, 3)).Copy _ Destination:=ActiveSheet.Range("A1") End With Clever gedacht, würde aber bei mir so nicht gehen. Kannst du aber nicht wissen, da ich natürlich ...
|
| Show full article (0.89Kb) · Show article thread |
Author: Andreas Eibach
Date: May 13, 2010 19:55
...@gmx.de> wrote: Alexander Wolff schrieb am 13.05.2010 16:53 Uhr: With Sheets("Tabelle1") Range(.Cells(i, 1), .Cells(i, 3)).Copy _ Destination:=ActiveSheet.Cells(k, 1) End With Sheets("Tabelle1").Cells(i,1).Resize(,3).Copy ActiveSheet.Cells(k,1) würde Range, With-Block und ein Cells sparen. Dafür kommt Resize dazu. Genial!! Vielen Dank, Peter _und_ ...
|
| Show full article (0.44Kb) · Show article thread |
|
Author: nntp
Date: May 13, 2010 18:31
The Following is up for Absolute Auction at www.PlunderHere.com: Item Name : The broad range of clinical use of phenytoin Auction Starts : Apr. 17 2010 02:35:01 Auction Ends : Jun.... : 1.00 Shipping From : United States - Zip Code: 58329 Description of item : Title the broad range of clinical use of phenytoin author barry h. smith and jack dreyfus, illustrated by yes illustrator - ...
|
| Show full article (0.99Kb) |
Author: nntp
Date: May 13, 2010 18:31
The Following is up for Absolute Auction at www.PlunderHere.com: Item Name : The broad range of clinical use of phenytoin Auction Starts : Apr. 17 2010 02:35:01 Auction Ends : Jun.... : 1.00 Shipping From : United States - Zip Code: 58329 Description of item : Title the broad range of clinical use of phenytoin author barry h. smith and jack dreyfus, illustrated by yes illustrator - ...
|
| Show full article (0.99Kb) |
Author: nntp
Date: May 13, 2010 18:31
The Following is up for Absolute Auction at www.PlunderHere.com: Item Name : The broad range of clinical use of phenytoin Auction Starts : Apr. 17 2010 02:35:01 Auction Ends : Jun.... : 1.00 Shipping From : United States - Zip Code: 58329 Description of item : Title the broad range of clinical use of phenytoin author barry h. smith and jack dreyfus, illustrated by yes illustrator - ...
|
| Show full article (0.99Kb) |
Author: Albert S.
Date: May 13, 2010 18:15
Thanks for the info, but I wanted to find the range of characters. I think I will have to try to loop through each character to find them. -- Albert S. "david" wrote: "Like" may also be used in Access VBA Public Function liketest(s) As Boolean liketest = (s Like "*b*") End Function FWIW, you can also use IN, using EVAL: Public Function InTest(s) As ...
|
| Show full article (1.82Kb) |
Author: Peter Schleif
Date: May 13, 2010 17:23
Alexander Wolff schrieb am 13.05.2010 16:53 Uhr: With Sheets("Tabelle1") Range(.Cells(i, 1), .Cells(i, 3)).Copy _ Destination:=ActiveSheet.Cells(k, 1) End With Sheets("Tabelle1").Cells(i,1).Resize(,3).Copy ActiveSheet.Cells(k,1) würde Range, With-Block und ein Cells sparen. Dafür kommt Resize dazu. Peter
|
| Show full article (0.33Kb) · Show article thread |
Author: Alexander Wolff
Date: May 13, 2010 16:53
...i = 1 k = 4 'Claus' Loesung 'With Sheets("Tabelle1") ' .Range(.Cells(i, 1), .Cells(i, 3)).Copy _ '...:=ActiveSheet.Cells(k, 1) 'End With With Sheets("Tabelle1") Range(.Cells(i, 1), .Cells(i, 3)).Copy _ ... du nur die linke obere Zelle, so dass "Range()" entbehrlich ist. 2) Die beiden aufspannenden "..... Warum dort und nicht nur bei Range, wo sie entbehrlich sind? Weil man ...
|
| Show full article (0.68Kb) · Show article thread |
Author: nntp
Date: May 13, 2010 16:31
The Following is up for Absolute Auction at www.PlunderHere.com: Item Name : The deep range Auction Starts : Apr. 17 2010 02:30:03 Auction Ends : Jun. 12 2010 02:30:03 ... Bid : 62.49 Shipping From : United States - Zip Code: 58329 Description of item : Title the deep range author arthur c. clarke illustrator - book condition very good size - jacket condition good binding hard ...
|
| Show full article (1.00Kb) |
Author: nntp
Date: May 13, 2010 16:31
The Following is up for Absolute Auction at www.PlunderHere.com: Item Name : The deep range Auction Starts : Apr. 17 2010 02:30:03 Auction Ends : Jun. 12 2010 02:30:03 ... Bid : 62.49 Shipping From : United States - Zip Code: 58329 Description of item : Title the deep range author arthur c. clarke illustrator - book condition very good size - jacket condition good binding hard ...
|
| Show full article (1.00Kb) |
|
|
|
1 ·
2 ·
3 ·
4 ·
5 ·
6 ·
7 ·
8 ·
9 ·
next |
|
|
