| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range
hi...
i want to replace Range("AK73:AO102") ...proper address so as to remove the hardcoding. i know the lastcell number of my sheet . but how do i replace the above with proper using '&' ... i tried but it doesn't work ! Application.CutCopyMode = False Selection.AutoFill Destination:=Range("AK73:AO102"), Type:=xlFillDefault Range("AK73:AO102").Select thanks monika |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range
Hi Monika
try Range("AK73:AO" & last_row_var) -- Regards Frank Kabel Frankfurt, Germany monika wrote: hi... i want to replace Range("AK73:AO102") ...proper address so as to remove the hardcoding. i know the lastcell number of my sheet . but how do i replace the above with proper using '&' ... i tried but it doesn't work ! Application.CutCopyMode = False Selection.AutoFill Destination:=Range("AK73:AO102"), Type:=xlFillDefault Range("AK73:AO102").Select thanks monika |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range
no..say column AK heading is "package" and column AO heading is "Pins".
I will find add as : set range1 = cells.find("Package") set range2 = cells.find("Pins") now i know from which column to start. say its range1.column now i want to replace....Range("AK73:AO102") as: range(range1.column & lnewrng.row & ":" & range2.column & lastcellnum) i tried a few combinations like this ... .which didn't work. I hope i am clear thanks Monika "Frank Kabel" wrote in message ... Hi Monika try Range("AK73:AO" & last_row_var) -- Regards Frank Kabel Frankfurt, Germany monika wrote: hi... i want to replace Range("AK73:AO102") ...proper address so as to remove the hardcoding. i know the lastcell number of my sheet . but how do i replace the above with proper using '&' ... i tried but it doesn't work ! Application.CutCopyMode = False Selection.AutoFill Destination:=Range("AK73:AO102"), Type:=xlFillDefault Range("AK73:AO102").Select thanks monika |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range
Monika,
How about Set myRange = Range(range1,range2) Application.CutCopyMode = False Selection.AutoFill Destination:=myRange,Type:=xlFillDefault myRange.Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "monika" wrote in message ... no..say column AK heading is "package" and column AO heading is "Pins". I will find add as : set range1 = cells.find("Package") set range2 = cells.find("Pins") now i know from which column to start. say its range1.column now i want to replace....Range("AK73:AO102") as: range(range1.column & lnewrng.row & ":" & range2.column & lastcellnum) i tried a few combinations like this ... .which didn't work. I hope i am clear thanks Monika "Frank Kabel" wrote in message ... Hi Monika try Range("AK73:AO" & last_row_var) -- Regards Frank Kabel Frankfurt, Germany monika wrote: hi... i want to replace Range("AK73:AO102") ...proper address so as to remove the hardcoding. i know the lastcell number of my sheet . but how do i replace the above with proper using '&' ... i tried but it doesn't work ! Application.CutCopyMode = False Selection.AutoFill Destination:=Range("AK73:AO102"), Type:=xlFillDefault Range("AK73:AO102").Select thanks monika |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range
but what about my row and lastcell num...
i am starting this particular thing from row 73 .. till the lastcellnum.... "Bob Phillips" wrote in message ... Monika, How about Set myRange = Range(range1,range2) Application.CutCopyMode = False Selection.AutoFill Destination:=myRange,Type:=xlFillDefault myRange.Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "monika" wrote in message ... no..say column AK heading is "package" and column AO heading is "Pins". I will find add as : set range1 = cells.find("Package") set range2 = cells.find("Pins") now i know from which column to start. say its range1.column now i want to replace....Range("AK73:AO102") as: range(range1.column & lnewrng.row & ":" & range2.column & lastcellnum) i tried a few combinations like this ... .which didn't work. I hope i am clear thanks Monika "Frank Kabel" wrote in message ... Hi Monika try Range("AK73:AO" & last_row_var) -- Regards Frank Kabel Frankfurt, Germany monika wrote: hi... i want to replace Range("AK73:AO102") ...proper address so as to remove the hardcoding. i know the lastcell number of my sheet . but how do i replace the above with proper using '&' ... i tried but it doesn't work ! Application.CutCopyMode = False Selection.AutoFill Destination:=Range("AK73:AO102"), Type:=xlFillDefault Range("AK73:AO102").Select thanks monika |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range
I assume that you used those in creating range1 and range2.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "monika" wrote in message ... but what about my row and lastcell num... i am starting this particular thing from row 73 .. till the lastcellnum.... "Bob Phillips" wrote in message ... Monika, How about Set myRange = Range(range1,range2) Application.CutCopyMode = False Selection.AutoFill Destination:=myRange,Type:=xlFillDefault myRange.Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "monika" wrote in message ... no..say column AK heading is "package" and column AO heading is "Pins". I will find add as : set range1 = cells.find("Package") set range2 = cells.find("Pins") now i know from which column to start. say its range1.column now i want to replace....Range("AK73:AO102") as: range(range1.column & lnewrng.row & ":" & range2.column & lastcellnum) i tried a few combinations like this ... .which didn't work. I hope i am clear thanks Monika "Frank Kabel" wrote in message ... Hi Monika try Range("AK73:AO" & last_row_var) -- Regards Frank Kabel Frankfurt, Germany monika wrote: hi... i want to replace Range("AK73:AO102") ...proper address so as to remove the hardcoding. i know the lastcell number of my sheet . but how do i replace the above with proper using '&' ... i tried but it doesn't work ! Application.CutCopyMode = False Selection.AutoFill Destination:=Range("AK73:AO102"), Type:=xlFillDefault Range("AK73:AO102").Select thanks monika |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming | |||
Linear Mode
