| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable range
You are welcome! Thanks for the feedback!
Stefi farid2001 ezt *rta: Stefi Thank you very much, your code worked very well!! Regards farid2001 "Stefi" wrote: RngEnd = Range("A1").End(xlDown).Row gives the No of the last used row. Use this No in cell references, e.g. Range("A" & RngEnd) instead of Range("A3800") Regards, Stefi farid2001 ezt *rta: Hello, I need help with code. I have a macro that I use to process each calling card account's information. A B C D etc. Date Number_dialed Location Duration all columns have the same number of rows, but this number changes depending of the amount of calls made from each account. I have set the fixed range in my macro from 2:3800, but most of the time the number of raws do'nt exceed 1000 Is there a way to just process the number of raws in each account instead of going the full 3800? Your help will be grately apreciated Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range to VLOOKUP as a Variable (range in another file) | Excel Programming | |||
| select range and put range address in variable | Excel Programming | |||
| Macro to copy a specified range to a variable range | Excel Programming | |||
| setting a range variable equal to the value of a string variable | Excel Programming | |||
| Problem trying to us a range variable as an array variable | Excel Programming | |||
Threaded Mode
