Re: variable range in a macro

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Al,

Assume data starts in A1 and that there is a blank row below, and a blank
column to the right, of the data, then your data can be defined by:

ActiveSheet.Range("A1").CurrentRegion

---
Regards,
Norman



"AMK" <AMK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2ACC5FE1-39F0-4E07-A2C0-92D0A5A469EE@xxxxxxxxxxxxxxxx
>I have a worksheet where the number of rows and columns vary each time I
> process the data.
> I want to transpose the cols and rows but need to set the range before I
> copy. There may not be any data in the XY cell. Is there a way to do this
> in
> a macro?
> Thanks for any help.
> --
> Al


.

Relevant Pages

  • Re: Clear cells
    ... number" AND the "year" in cols B thru I ... I don't know of a way to clear a cell without using a macro or the ... From there you can test against A1 for the control number, ... You can use the macro recorder to see how to use the find method. ...
    (microsoft.public.excel.programming)
  • Re: Macro to change value 2 cols over from search
    ... > appreciate it.I like to create a macro to change to value of a cell 2 ... > cols left of a search string,same row.I have a sheet with 25 cols and ... > ?.The search string is usually but not always the same col,the value to ...
    (microsoft.public.excel.programming)
  • Re: Hiding changing columns
    ... ONLY until you double click any cell in the visible column again. ... I want to be able to just see Cols A-E, that days column and Cols HA-HD. ... That would Hide Cols F - GZ and unhide Col F for Oct 1. ... That would allow the user to just click that days macro. ...
    (microsoft.public.excel.programming)
  • Re: Hiding changing columns
    ... ONLY until you double click any cell in the visible column again. ... I want to be able to just see Cols A-E, that days column and Cols HA-HD. ... That would Hide Cols F - GZ and unhide Col F for Oct 1. ... Is there any way I can just write one macro that would work for whatever ...
    (microsoft.public.excel.programming)
  • Re: Not understanding If Not..Then nothing
    ... That begs the question: If you do a "Find" in a macro, ... if a cell with that value was found? ... Prev by Date: ...
    (microsoft.public.excel.programming)