Please support DU during Summer Fund Drive Week, August 18-25 2025!

Pick Your
Battles
Get Ur Rest
Look for Joy
We have
A Big Fight
Ahead

You still
have time to
to send some
money DU`s
way. Support
the summer
fund drive!

I have
DU friends
everywhere.

Rebellions
are built
on HOPE

DU
keeps
HOPE
alive

Thank you

EarlG

Check out
all the stickies
on Grovelbot's
Big Board!

Apple Users

tiredtoo

(2,949 posts) Tue Apr 13, 2021, 01:21 AM Apr 2021

is there a way to create a range of cells using a calculated value

In excel macro

example Range(b1: b(val(c41)).select
I know this isn't correct but if you know what i am trying to do, maybe you could tell me the correct way.
C41 has a value after all data is entered. the data changes weekly.

1 replies

= new reply since forum marked as read

Highlight:

is there a way to create a range of cells using a calculated value (Original Post) tiredtoo Apr 2021 OP

I would just set a variable to that value. Foolacious Apr 2021 #1

Foolacious

(539 posts)

1. I would just set a variable to that value.

Reply to tiredtoo (Original post)

Tue Apr 13, 2021, 02:09 AM

Apr 2021

Something like this:

Dim nVal As Long
nVal = Range("C41:C41" ).Value
Range("B1:B" & nVal).Select

But if it's important to get it all into one line of code, you can do this, though it looks a bit opaque:

Range("B1:B" & Range("C41:C41" ).Value).Select

Reply to this discussion