This might be a silly question, bit here goes anyways:
Have macro's to repopulate formulas in a given worksheet should it
become necessary. If the tab name changes, the macro which calls for
a certain sheet()select will not find the sheet referenced in the
macro and the macro will not do its job.
Dear Expet please tell me that how can you excel button in vba coding.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Sub vlookup()
Dim lookfor As Range
Dim rng As Range
Dim col As Integer
Set lookfor = ActiveCell.Offset(0, -1)
Set rng = ActiveWorkbook.Worksheets(MV).Range(A:C)
col = 3
dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col,
0)
End Sub
On Fri, Dec 10, 2010 at 10:02
No attachment found.
On Fri, Dec 10, 2010 at 3:16 PM, lucky singh lucky60...@gmail.com wrote:
Hi All,
kindly help me to get the collaction date with the help of an formula...
please refer the attachment...
Regards,
Lucky
--
Dear Jai,
The question is not clear but I can try to answer. I hope you are
asking how to assign VBA coding to button in Excel. If this is right,
Follow the below steps :
1) Go to developer tab
2) Click on Insert button on Controls Group.
3) Select a button from Form Controls
4) Design a button
Hi Dharti,
Good Question!
I just did a quick check of the VBproject object model and don't find
anything that indicates it is possible to protect or unprotect a
VBproject from within VBA. VBA can only test (read-only) whether a
VBproject is protected or not. It would have very interesting
Dear members, An awesome opportunity to win prize and be closer to
Microsoft Excel. What you need to do ? Just submit the idea or feature
that you would like to implement in upcoming version of excel. The best
five ideas with maximum votes will get the $10 prize. Not only you can
submit the idea
Submit your VOTE , IDEA @ http://goo.gl/mod/psLh
Thanks.
--
--
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 @