Continuing Difficulties W/ Sum For Variable-length Column

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

Bob,

I have a column of numbers (each cell contains a number), with a fixe
starting cell but a variable ending cell. I want the macro to assign
Name (Workbook definition) to this range.

Chuckles12
 
Set TopCell = Range("A1")
Range(TopCell, TopCell.End(xlDown)).Name = "SomeName"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Macro to Sum a Variable-Length Range (a Column) 1
Continuing Difficulties W/ Sum For Variable-length Column 2
Sum a variable length column 1
Simple Variable to someone 5
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Best Practice for Public Variables for Column Headings 2
Macro to Create Name Ranges for variable lengths of Data 9
Some trouble assigning a string to a variable 22

Back
Top