| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic Range in ADO
Dear experts:
This is my VBA I learned from Ron de Bruin's website 'Get the cell values and copy it in the destrange 'Change the Sheet name and range as you like GetData FName(N), "PO New (2)", "A1:C1", destrange, False, False How can I cnange the range( A1:C1 ) to dynamic range since the data in other files could change, so I want to always update the combined data. Many thanks, Frank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting the absolute range address from a dynamic named range | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| copying dynamic range based on cell outside of range | Excel Programming | |||
| select dynamic range with dynamic start point | Excel Programming | |||
| Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
Hybrid Mode
