Dear Vasant,
Thanks friend. It's good.
Regards,
Dilan
On Thu, Jul 7, 2011 at 8:14 PM, Vasant vasant...@gmail.com wrote:
Try this...
Sub test()
Dim Wksht As Worksheet
Set Wksht = ThisWorkbook.Worksheets(1)
Lrow = Wksht.Range(C65536).End(xlUp).Row
For x = 10 To Lrow
If Wksht.Cells(x, 5) Then
Vr = Wksht.Cells(x, 5)
Wksht.Cells(x, 5).Formula = = Trim(Str(Vr)) *$H$1
End If
Next x
End Sub
On Thu, Jul 7, 2011 at 8:07 PM, Dilan De Silva dila...@gmail.com wrote:
Dear Friends,
I have a BOQ(Bills of Quantity) and I need to add a formula to each rate.
The formula should be as follow.
=rate*(Constant cell reference)
For an example;
The rate on cell E18 is 250.00 (see attached BOQ)
It should like this after run the macro
'=250*($H$1)
It need to repeat for each rate when macro runs.
Can any one help?
Thanks in advance
Regards,
Dilan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Regards
Vasant
skype Id: vasantjob
http://facebook.com/vasantjob
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel