By11
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 5 articles for 0.302 sec
Hi, BE11 - BY11 is 21 cells. If lastrow evaluates as 40 as in your example what goes in the other 19 cells? Mike "leerem" wrote: > i'll try to exlpain a bit better; I need to select cells BE11:BY11 and copy > the contents of these cells to BE12:BE by the number of rows in columb AX. > eg Col AX = 40 lines > > select BE11:BY11 and copy the contents of these cell to > Col ("     

Group: microsoft.public.excel.misc · Group Profile · Search for By11 in microsoft.public.excel.misc
Author: Mike H
Date: Aug 4, 2008 02:54

i'll try to exlpain a bit better; I need to select cells BE11:BY11 and copy the contents of these cells to BE12:BE by the number of rows in columb AX. eg Col AX = 40 lines select BE11:BY11 and copy the contents of these cell to Col (" BE12:BE12" + the no. of rows in AX" eg 40 therby BE12:BE52 "Mike H" wrote: Hi, Your question is very ambiguous. You can only paste what
Show full article (1.33Kb) · Show article thread
Hi, Your question is very ambiguous. You can only paste what you have copied so the decision needs to be made at copy time. lastrow = Cells(Rows.Count, "ax").End(xlUp).Row Range("BE" & lastrow & ":BY" & lastrow).Copy Is that what yo mean? Mike "leerem" wrote: > Sorry to be a pain once again. > > I need to copy over rows BE to BY but only by the number of rows in column AX     

Group: microsoft.public.excel.misc · Group Profile · Search for By11 in microsoft.public.excel.misc
Author: leerem
Date: Aug 4, 2008 02:41

Sorry to be a pain once again. I need to copy over rows BE to BY but only by the number of rows in column AX I've tried the code as below but the code comes to a halt on line 3 what have i done wrong , its probabley simple but I cant see it... Lastrow = Cells(Rows.Count, "ax").End(xlUp).Row Range("BE11:BY11").Copy Range("Be12:Be" & Lastrow).PasteSpecial Paste:=xlPasteAll, operation
Show full article (1.12Kb) · Show article thread
Needed large magnifying glass to read T&Cs today and still not very clear!! Holiday in Tel Aviv Three-night, B&B, holiday for two, at the four-star Basel Hotel. Prize includes return flights from the Luton or Manchester with on-board meals, airport security/departure/entry taxes and fuel surcharges. Travel to Tel Aviv starts from 1/11/07 and break must be taken by11/2/08, excluding 3/12/07     

Group: microsoft.public.excel.misc · Group Profile · Search for By11 in microsoft.public.excel.misc
Author: Mike H
Date: Aug 4, 2008 02:24

Show full article (0.75Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for By11 in microsoft.public.excel.misc
Author: leerem
Date: Aug 4, 2008 02:01

Show full article (0.45Kb)
    

Group: uk.rec.competitions · Group Profile · Search for By11 in uk.rec.competitions
Author: Graham
Date: Aug 4, 2007 04:54

Show full article (1.07Kb)