View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Need help with adding variables to cell addresses

Range("D2").Value = ActiveCell.Address(0,0)


Range( "B" & 17 + Range("D3).Value)


--
Regards,
Tom Ogilvy





"Matt" wrote in message
ups.com...
Hi There,

I ran into more problems ...

Now I have a macro which determines the start cell of a range of cells
with this function:

Range("D2").Value = ActiveCell.Address

in cell D2 it will put like $B$17.

- How can i make it so it doesnt put $ in there but just B17?

- I have a second function:

ActiveCell.FormulaR1C1 = "=count(R5C2:R65000C2)

which determines how many used cell sare in the column .
and puts the value in lets say D3


Now I need to find the address of the last cell which is B(17+D3).

But I cant get it to work :( It wont add up and I tried Left function
to seperate values but it will only worh on a string.

Any help appreciated :)

Matt