| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Going down until the data stops....
Howdie! I have a block of data of variable length, depending upon when it is looked at (entries are added or deleted at points in time). I want to apply the same macro to the data (at the different varying points in time) So the question is does anyone know VB command to select (ie go down the rows and across the columns) to select all visible data...? Note - data at the bottom of Column A, and at the end of Row S will always be the bottom two corent points... Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Going down until the data stops....
Darin,
Try using the UsedRange property. For example " ActiveSheet.UsedRange.Select". "Darin Kramer" wrote: Howdie! I have a block of data of variable length, depending upon when it is looked at (entries are added or deleted at points in time). I want to apply the same macro to the data (at the different varying points in time) So the question is does anyone know VB command to select (ie go down the rows and across the columns) to select all visible data...? Note - data at the bottom of Column A, and at the end of Row S will always be the bottom two corent points... Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Going down until the data stops....
Hi
see: http://www.xldynamic.com/source/xld.LastValue.html#vba "Darin Kramer" wrote: Howdie! I have a block of data of variable length, depending upon when it is looked at (entries are added or deleted at points in time). I want to apply the same macro to the data (at the different varying points in time) So the question is does anyone know VB command to select (ie go down the rows and across the columns) to select all visible data...? Note - data at the bottom of Column A, and at the end of Row S will always be the bottom two corent points... Thanks D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Going down until the data stops....
Howdie...
I looked at the site, and have found thefunction that I want... However how do I get VBA to run this function.... - I cant seem to house it inside a Sub Macro.. If its afunctionsitting in a module, where is the result going to be displayed, or should it just select the text itself.... I cant seem to get this one working... (Apologies for the dumb questionaire, asi I try to teach myself more VBA...) *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation in XL2007 suddenly stops functioning | Excel Discussion (Misc queries) | |||
| Macro stops with "Large Amount of Data" Message | Excel Discussion (Misc queries) | |||
| Area chart dives to zero when data series stops | Charts and Charting in Excel | |||
| Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
| web query - stops at login to private data | Excel Discussion (Misc queries) | |||
Linear Mode
