Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VARIABLE IN EXCEL MACRO
Partially, I also expected the answer to give a solution for selecting a
specific part of a block like from a certain cell to 2O lines below and/or 5 colums to the right. "Stopher" wrote: Ulrik loves horses wrote: Try to copy various data from various places to another sheet using Excel Macro, as this is required on a weekly basis. However the data which needs copied is always in blocks, but the number of Lines as well as the number of columns is changing. Will need to take variable selection criteria in Excel macro as this is possible in Excel. Go to a certain cell select an array using <End Left <End Down functions. How would you translate these instructions in a Macro? What about: ' Go to a certain cell Range ("A1"). select ' Select the current block of data Selection.CurrentRegion.Select Does this help any?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VARIABLE IN EXCEL MACRO
set rng = Range("B9").Resize(20,5)
msgbox rng.Address rng.Select -- Regards, Tom Ogilvy "Ulrik loves horses" wrote in message ... Partially, I also expected the answer to give a solution for selecting a specific part of a block like from a certain cell to 2O lines below and/or 5 colums to the right. "Stopher" wrote: Ulrik loves horses wrote: Try to copy various data from various places to another sheet using Excel Macro, as this is required on a weekly basis. However the data which needs copied is always in blocks, but the number of Lines as well as the number of columns is changing. Will need to take variable selection criteria in Excel macro as this is possible in Excel. Go to a certain cell select an array using <End Left <End Down functions. How would you translate these instructions in a Macro? What about: ' Go to a certain cell Range ("A1"). select ' Select the current block of data Selection.CurrentRegion.Select Does this help any?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VARIABLE IN EXCEL MACRO
Thanks for the info but the 20 and the 5 were just an example . These
variables and will change from day to day, so I really would like to work also with the end left and sometimes with the end right instructions. "Tom Ogilvy" wrote: set rng = Range("B9").Resize(20,5) msgbox rng.Address rng.Select -- Regards, Tom Ogilvy "Ulrik loves horses" wrote in message ... Partially, I also expected the answer to give a solution for selecting a specific part of a block like from a certain cell to 2O lines below and/or 5 colums to the right. "Stopher" wrote: Ulrik loves horses wrote: Try to copy various data from various places to another sheet using Excel Macro, as this is required on a weekly basis. However the data which needs copied is always in blocks, but the number of Lines as well as the number of columns is changing. Will need to take variable selection criteria in Excel macro as this is possible in Excel. Go to a certain cell select an array using <End Left <End Down functions. How would you translate these instructions in a Macro? What about: ' Go to a certain cell Range ("A1"). select ' Select the current block of data Selection.CurrentRegion.Select Does this help any?? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VARIABLE IN EXCEL MACRO
If you in the upper right corner of your data then:
range(activecell.End(xltoLeft).End(xldown),activec ell).Select -- Regards, Tom Ogilvy "Ulrik loves horses" wrote in message ... Thanks for the info but the 20 and the 5 were just an example . These variables and will change from day to day, so I really would like to work also with the end left and sometimes with the end right instructions. "Tom Ogilvy" wrote: set rng = Range("B9").Resize(20,5) msgbox rng.Address rng.Select -- Regards, Tom Ogilvy "Ulrik loves horses" wrote in message ... Partially, I also expected the answer to give a solution for selecting a specific part of a block like from a certain cell to 2O lines below and/or 5 colums to the right. "Stopher" wrote: Ulrik loves horses wrote: Try to copy various data from various places to another sheet using Excel Macro, as this is required on a weekly basis. However the data which needs copied is always in blocks, but the number of Lines as well as the number of columns is changing. Will need to take variable selection criteria in Excel macro as this is possible in Excel. Go to a certain cell select an array using <End Left <End Down functions. How would you translate these instructions in a Macro? What about: ' Go to a certain cell Range ("A1"). select ' Select the current block of data Selection.CurrentRegion.Select Does this help any?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running a variable macro when any value is entered into a variable cell | Excel Programming | |||
How to set variable to cell value in excel macro | Excel Discussion (Misc queries) | |||
How do I set a macro to print variable number of pages in excel? | Excel Discussion (Misc queries) | |||
Macro Creating Variable and using variable in a SQL statement | Excel Programming | |||
entering formula using variable in Excel Macro | Excel Programming |