Windows 10: Excel VBA - selecting a cell in different sheet using GoTo and IF statement giving error.

Hi all,

I am trying to select a cell in different sheet in my code using nested IF and GoTo, however, I am getting Runtime error:1004

Code is as below.

I apologise, It might look very amateur :




:)

 

Better overview of different sheets in Microsoft Excel

I would like to suggest you a simple method to create Hyperlink of Sheet Name for easy navigation.





How it works:

• Press Ctrl+K to open the Insert Hyperlink dialog box.
  
• Click the Place in This Document button.
  
• Then link to the sheet, select Sheet name from Cell Reference & press OK.
  
• In Type the Cell reference write the Cell address which you want to
  attach with Sheet's Hyperlink.
  

Note,

• Repeat Step 1 to 3 for other Sheets.
  
• Using this method you can create Sheet's Name list in desire order.
  

 

Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

Just a wild shot in the dark ...

Didn't macros get recorded in worksheets before Excel switched to VBA?
- I can't think how far back this was. Possibly Excel 4 in the early 1990s.
- Of course, this would make no sense at all if your workbook had been created since, say, Excel 2007.

If your workbook is older than that I'd suggest
1 Create a new blank one then, with both open at once, use the sheet tab Move or copy ... to copy each sheet to the new blank workbook.
2 In the VBEditor of the new workbook, create two new modules [Functions, Procedures] and then just copy the code text across from one to the other.
3 In the VBEditor window of the old one, in the Microsoft Excel objects list select each sheet in turn {including ThisWorkbook} then right-click and select View code. If there is anything in any of them, copy it to the same place in the new workbook.





Denis

 

Storing Pictures in Excel Sheet

Hi Now,



I posted the following on the MSDN Excel forum, and the answer was that the suggested method (in particular the VBA) is not available.

But perhaps there is another way to accomplish the task?

I would be ever so thankfull for a good suggestion



Jos



PS: A have experience with VBA, VBScript



---- previously posted:



Hi,

My boss wants me to buy a PDA with Windows Mobile 6. The customer sends a

"normal" Excel-sheet of objects to be inspected. After loading into to PDA

the workers have to take a picture of objects that fail inspection. The

picture then has to be linked to the Mobile-sheet by means of a hyperlink.

I think this is possible used a bit of VBA in Excel, but does Excel Mobile

support VBA?

--

Jos



Answer something like,



I think a no to that.