| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to write (Selected range - 1)
I have a defined Name [Last], but I would like it to take 1 wor before [Last]
Right now I have Range("B31:O31", [Last]) I wnat it to be Range("B31:O31", [Last]-1) or something. How would I put this? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to write (Selected range - 1)
Is this in VBA or a spreadsheet formula?
[Last] would be an address if you want to work with the rows then [Last].Row-1 woud be a start. And if Last is supposed to be an address, then what would one mean by Last -1? Suppose Last is O31 is Last-1 N31 or O30 or...? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Damian" wrote: I have a defined Name [Last], but I would like it to take 1 wor before [Last] Right now I have Range("B31:O31", [Last]) I wnat it to be Range("B31:O31", [Last]-1) or something. How would I put this? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to write (Selected range - 1)
This is in VBA code.
Last is defined as "B104:O104" This will stay constant and will change if rows are deleted.. So If I want to do an operation one Row before Last I can use what you said? [Last].Row-1? Thank you "Shane Devenshire" wrote: Is this in VBA or a spreadsheet formula? [Last] would be an address if you want to work with the rows then [Last].Row-1 woud be a start. And if Last is supposed to be an address, then what would one mean by Last -1? Suppose Last is O31 is Last-1 N31 or O30 or...? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Damian" wrote: I have a defined Name [Last], but I would like it to take 1 wor before [Last] Right now I have Range("B31:O31", [Last]) I wnat it to be Range("B31:O31", [Last]-1) or something. How would I put this? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write formula to check a range of cells? | Excel Worksheet Functions | |||
| Write macro to lock selected sheet when run | Excel Discussion (Misc queries) | |||
| How do I write an Excel macro when the cell range changes weekly? | Excel Discussion (Misc queries) | |||
| Appearance of a selected range | Excel Discussion (Misc queries) | |||
| How to write a quote formula using only the cells selected with va | Excel Worksheet Functions | |||
Linear Mode
