Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro not starting
I've got a strange one here. On some of my macines this
macro works while others don't. I've checked to be sure everyone's on the same rev....still no luck. Any ideas? Here's the macro that is being used: Public Function GetValueFromSheet(C As String, L As Integer) As String FName = ActiveSheet.Range("D1:E1").Cells(1, 1).Value SName = ActiveSheet.Range("D1:E1").Cells(1, 2).Value GetValueFromSheet = Workbooks(FName).Worksheets (SName).Range(C & L).Value End Function And the cell formula looks like this: |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro not starting
Try this and let me know if it makes a difference:
Public Function GetValueFromSheet(C As String, L As Integer) As String FName = ActiveSheet.Cells(1, 4).Value SName = ActiveSheet.Cells(1, 5).Value GetValueFromSheet = Workbooks(FName).Worksheets.(SName).Range(C L).Value End Function - Piku -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
starting macro again | Excel Discussion (Misc queries) | |||
Starting macro | Excel Discussion (Misc queries) | |||
Starting A Macro | Excel Discussion (Misc queries) | |||
starting a macro at startup | Excel Discussion (Misc queries) | |||
Starting a macro with the IF function | Excel Worksheet Functions |