-
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.
jonas svaerke
-
Save excel sheet as PDF (only one sheet)
Hi all, I currently have a macro that converts my excel sheet into a PDF and saves it in a designated folder. However, I only want it to save the first sheet as a PDF, and ignore my other sheets, which it will not do at the moment. My code looks as follows: Option Explicit Sub...- Jyggalag
- Thread
- code excel ez win 16-0 ezz ezzus sverkus fast haha ez win guys help jonas svaerke macro pdf roessel sanoj ekrævs save as pdf svorktallica vba vba code vlookup
- Replies: 14
- Forum: Excel Questions
-
IndexMatch formula based on name of Excel Sheet
Hi all, I currently have this setup: Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0)) My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now. I want my formula to pull in data based on the value in column...- Jyggalag
- Thread
- christian røssel code excel ezzzzzzzzzzzz fast formula help index indexmatch jonas svaerke match sanoj ekrævs sonaj jværke vlookup
- Replies: 3
- Forum: Excel Questions
-
Help me fix my VBA code (attachment error)
Hi all, I have this code attached to a macro: Option Explicit Private Const FilePath As String = "R:\LXI_DLL\ZGJ_COMMON\FLD COMP FOLDER\12-FOLDER\TOPIC 2\ATTACHMENTS\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet...- Jyggalag
- Thread
- code easy ezzzzzzzzzzzz fast formula help jonas svaerke sverktallica svonkie svonkieboy svorkieboy svorkster svorktallica vba
- Replies: 2
- Forum: Excel Questions
