-
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.
sheets1.select
-
J
ChDir
Hello, Why doesn't this work? The error is in the line that starts with ChDir abc & ""... abc = "C:\a\b\c" f = Range("A1") Sheets("1").Select ChDir abc & "\" & f & "\" & "\g" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "a" & "_" & f & "_" &...- jebenexcel
- Thread
- abc filename= formatnow sheets1.select type=xltypepdf
- Replies: 4
- Forum: Excel Questions
-
M
Issue incrementing a variable
Hi Guys, I am hoping someone can pin point what I am doing wrong here. I am trying to auto generate 31 sheets, each sheet is named numerically from 1-31 My issue is that every 10th sheet gives me a number that is not correct. The sheets end up getting labeled like the following. (sheets...- MrFlooglebinder
- Thread
- issue sheet sheetname sheets sheets1.select
- Replies: 3
- Forum: Excel Questions
-
M
Simple VBA code working in both english german and french versions of excel?
Hello friends. I have a code i used in several worksheets, however some are german french and english - how do i make sure the same code works in all - or alternatively, how do i figure out the other language variations to the same code? The code is below and works fine in english excel but not...- mboas
- Thread
- code english german sheets1.select works
- Replies: 1
- Forum: Excel Questions
