Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello, I am trying to set Range dynamically with a variable and just can't
seem to figure out the proper method. Any help greatly appreciated. Plus, if someone knows a great tutorial on how to use Range, Cells, etc that would be appreciated also! Here is my code snippet which does not seem to properly define the range (Note: My var, colNum, is properly populating the column number field): Set rng = Range(Range(Cells(2, colNum)), Range(Cells(2, colNum)).End(xlDown)) TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
Setting a default sort for a range | New Users to Excel | |||
dynamically select a range of cells for use in a formula | Excel Worksheet Functions | |||
Setting source data range with Charts | Charts and Charting in Excel | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions |