thanhvanchi
12-08-2016, 07:57 PM
Hello everyone!
So I'm trying to do a complicated data transfer between one "master" sheet and multiple "sub" sheets.
Today is my first day with Excel VBA so I'm pretty lost haha.
I decided to start small and transfer data from one cell of one sheet to the other sheet but I keep on getting this error of "Cannot jump to 'Sheets' because it is hidden".
Can anyone please lend me a hand? Thanks in advance.
Sub transfer()
Dim strSourceSheet AsString, strDestinationSheet AsString, sourceData AsString
strSourceSheet ="profile list"
Sheets(strSourceSheet).Activate
sourceData = Sheets(strSourceSheet).Cells(30,37).Value
strDestinationSheet ="RADIANT OPTO-ELECTRONICS CORP."
Sheets(strDestinationSheet).Activate
Sheets(strDestinationSheet).Cells(C,11)= sourceData
End Sub
Thank's a lot!
So I'm trying to do a complicated data transfer between one "master" sheet and multiple "sub" sheets.
Today is my first day with Excel VBA so I'm pretty lost haha.
I decided to start small and transfer data from one cell of one sheet to the other sheet but I keep on getting this error of "Cannot jump to 'Sheets' because it is hidden".
Can anyone please lend me a hand? Thanks in advance.
Sub transfer()
Dim strSourceSheet AsString, strDestinationSheet AsString, sourceData AsString
strSourceSheet ="profile list"
Sheets(strSourceSheet).Activate
sourceData = Sheets(strSourceSheet).Cells(30,37).Value
strDestinationSheet ="RADIANT OPTO-ELECTRONICS CORP."
Sheets(strDestinationSheet).Activate
Sheets(strDestinationSheet).Cells(C,11)= sourceData
End Sub
Thank's a lot!