-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
wbtarget
-
J
Check if a file can be opened or not and delete if not
Hi, does anyone have a code that can go through a list of hyperlinks and check if they can be opened or not? Some may be corrupt which is the reason they cannot be opened. This is what I have so far but the error command doesn't seem to work. The aim is to delete the hyperlinks that cannot be...- Joe9238
- Thread
- codenames dim long opened wbtarget
- Replies: 1
- Forum: Excel Questions
-
F
Need VBA to copy active row and paste it in last row of another sheet
Need macro to copy active row and paste it in xfiles-xsheets-lastrow. With same format and everything. I've tried this : <code>Option Explicit Sub copypasterow() Dim wbTarget As Workbook Selection.EntireRow.Copy Set wbTarget =...- forginganewone
- Thread
- dim explicit row wbtarget worksheetendrow
- Replies: 11
- Forum: Excel Questions
-
F
runtime error 1004 pastespecial method of range class failed
I keep getting this error "runtime error 1004 pastespecial method of range class failed" on following code : Option Explicit Sub copypasterow() ' ' chequerecieving Macro ' copy active row to another workbooks last row ' ' Keyboard Shortcut: Ctrl+l ' Dim wbTarget As Workbook...- forginganewone
- Thread
- error failed file runtime wbtarget
- Replies: 15
- Forum: Excel Questions
