How to grab a reference into VB

  • Thread starter Thread starter sb1920alk
  • Start date Start date
S

sb1920alk

I have a macro that publishes a sheet as a webpage in the range "$A$1:$K$56"
but I'd like to change it to "$A$1:$K$**" instead where the ** number is
pulled from a cell, say P1 based on the result of a formula in P1 because I
have to manually change the macro every time the number of rows changes. Is
that possible?

Thanks,
 
you should be able to use:
Range("A1:K" & Range("P1").Value)

assuming you are working with the activesheet. otherwise qualify the range
references with the proper worksheet references.
 
"A1:K" & Range("P1").Value is what worked, I kept getting an error with
Range("A1:K" & Range("P1").Value)

Thanks for pointing me in the right direction.
 

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

UDF returns #NUM! with F9 or Application.CalculateFull if sheet notactive 11
Grab the right please 1
how to: c.value = "a cell value" 5
Clearing formulas 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
writing formulas in VB - referring to the values contained in cell 4
Check a Check Box with VB 10
Function in a VBA prog. or something like that 4

Back
Top