View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Damian Damian is offline
external usenet poster
 
Posts: 71
Default 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.