Hello,
In my VBA, for a cell I am calling a formula. Let's say
Range("B2").Formula="=SUM($C$2:$C$500)"
But My last cell is not fixed. It keeps on Changing. Thus I want $C$500 also to change as per the number of rows in column C.
Can i get any assistance on getting this dynamic range coded... I have given my entire syntax used in the code tag.
Thanks!
Please Login or Register to view this content.
Last edited by Srikanth H N; 03-03-2014 at 11:17 PM.
Hi,
To make the last row dynamic, changeto something like this:Please Login or Register to view this content.I hope this helpsPlease Login or Register to view this content.
Thnak you ajryan... It's working...
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks