Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

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 [View all]

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 [View all] tiredtoo Apr 2021 OP

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