What is the Best/Simplest way to define RANGES

[BIGTONE559]

Greetings,

I have a range that will change from month to month. My current code defines that range as D5:D30. (Just for trial purposes) In actuality the database is from D2:D9319. However i'd like the code to remain unchange from week to week. I would imagine that i would need to dim a range but i figured i seek help of more knowledgeable people.

Please help!!!! and let me know if there are enough details.

 

[BIGTONE559]

My question is in regards to Dynamic Ranges! thought i'd clarify


thanks again

 

[Marcelo Branco]

Hi,

Do you want to define a dynamic named-range in the worksheet? In this case, your range has numbers , text, mixed?

or

inside VBA get the range like

Dim lastRow as Long, rng as Range
 
With Sheets("Sheet1")
   lastRow = .Cells(.rows.count, "B").End(xlUp).Row
 
  Set rng = .Range("B2:B" & lastRow)
End With

M.

 

[BIGTONE559]

Marcelo i was thinking similar to your second example. I want to define the range from vba. In your example you used B so I'm assuming i would just change that to D.

I'm going to try your example out it appears to be exactly what i'm looking for.

 

[Marcelo Branco]

Marcelo i was thinking similar to your second example. I want to define the range from vba. In your example you used B so I'm assuming i would just change that to D.

I'm going to try your example out it appears to be exactly what i'm looking for.

Hi,

Yes change B to D. I dont know why i've used B...

M.