-
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.
activesheet.name
-
A
N= activesheet.name
Hi What is the code change to change 'DataSheet1' to N where n = activesheet.name Original code: Range(Cells(10, 1), Cells(j, 1)).Value = "=IFERROR(INDEX(List!C[1],MATCH('DataSheet1'!RC[4],List!C[1],0),1),0)" This doesnt work: Range(Cells(10, 1), Cells(j, 1)).Value =...- AndyDevine1
- Thread
- 1.value activesheet.name change code rangecells10
- Replies: 2
- Forum: Excel Questions
-
H
Change code to dynamic range
Hello, I have this code and I would like it to stop at the last row of the data in each sheet. Option Explicit Sub LoopThroughSheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ActiveSheet.[d1:d33] = ActiveSheet.Name...- hanz753
- Thread
- activesheet.name activesheet.[d1d33] activeworkbook.worksheets code ws.ranged2d33
- Replies: 6
- Forum: Excel Questions
-
Odd behaviour of creating a table in VBA
I'm creating a lot of tables so am using VBA. This doesn't work ... InputName = "Input_" & ActiveSheet.Name ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$12:$C$38"), , xlYes).Name = Input_Name But this does ... ActiveSheet.ListObjects.Add(xlSrcRange, Range("$B$12:$C$38"), , xlYes).Name =...- Johnny C
- Thread
- activesheet.name input range$b$12$c$38 vba xlyes.name
- Replies: 2
- Forum: Excel Questions
-
V
VBA - Enter Formula only if Sheet Exists
Hello, I am trying to write a macro that enters a Vlookup into a cell only if a corresponding tab exists on another workbbok to compare it to. I'm doing this to try to avoid the 'Select Sheet' Dialogue from appearing if there is no corresponding sheet on the other workbook. This is what I...- vba_monkey
- Thread
- activesheet.name end function previousreport sheet
- Replies: 1
- Forum: Excel Questions
-
A
VBA code to copy ActiveSheet.name to the Clipboard?
Excel friends, this should be an easy one: What is the code to copy the ActiveSheet.name to the clipboard? So, I can paste it anywhere I want outside the Excel workbook. Any help is appreciated. Thanks!- actjfc
- Thread
- activesheet.name clipboard
- Replies: 12
- Forum: Excel Questions
-
R
ActiveWorkbook.ActiveSheet.Name Run-time error 91 / Object variable not set
I am running the following code on one of my worksheets ("Deal Info" / Sheet3) however for some reason one of the users of this workbook is getting a Run-time error '91': Object variable or With block variable not set message when they open another workbook and this one is open. Here is the...- rickincanada
- Thread
- activesheet.name object variable runtime 91 error
- Replies: 5
- Forum: Excel Questions
-
M
Creating the same chart different workbook different sheet
Hi, I have lots of workbooks detailing specific data, I have started creating overview/summary charts detailing specific columns in each workbook. The format of the chart is the same, the columns the data is taken from are the same in each workbook. The two variables are the Workbook Name and...- MrMT
- Thread
- activesheet.name chart macro vba
- Replies: 4
- Forum: Excel Questions
-
S
How to use ActiveSheet.Name in sql query
Hi Guys, I have a script that is working well i am just trying to make it a little more efficent. The workbook is made of about 10 sheets. Each sheet has the name of business area. I am tring to set the criteria in the sql query to filter against this business area instead of filtering at the...- ServerDude
- Thread
- activesheet.name query sql vba
- Replies: 2
- Forum: Excel Questions
