LinkBack URL
About LinkBacks
I have many this extensive vba coding that works on 2 computers but not on others.
In this part of the code it gives me errors in the Set originsheet, set wkbkdest and set destsheet lines
Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim wkbkorigin As String
Dim wkbkdest As Workbook
Dim originsheet As Worksheet
Dim destsheet As Worksheet
wkbkorigin = ActiveWorkbook.Path & "\ABC"
Workbooks.Open Filename:=ActiveWorkbook.Path & "\ABC.xls"
Set originsheet = Workbooks("ABC").Worksheets("Sheet1")
Set wkbkdest = Workbooks("DEF")
Set destsheet = Workbooks("DEF").Worksheets("Autofill")
.
.
.
and also getting an error on other computers when I want to display an array that i've previously filled with data, into a range in a column
Set R = wkbkdest.Worksheets("Sheet3").Range("A1").Resize(UBound(strarray) + 1, 1)
R = Application.Transpose(strarray)
(I'm making the program for another computer)
Register To Reply
Bookmarks