wks.name

Hi - I'm trying to copy sheets not named Sheet1/2/3 to a new workbook and then prompt the user to save it. This is the code I'm using. Sub ExportFile() Application.ScreenUpdating = False Dim DstFile As String Dim TD As String TD = Format(Date, "mm-dd-yyyy") Dim wb As...

Its a huge formula iam trying to take cells in specific sheet to maser sheet. can anyone please fix the formula by using specific sheet and range,there are 4 more sheets,i need to consider different ranges in different sheets. thats y iam trying to use this formula. MyFormulas =...

Hi, I have a macro that is creating sheets and adding fomula to "ABSTRACT" sheet. i have 4 sheets in my workbook ( Product1 ) ( Product2 ) ( Product3 ) AND ( ABSTRACT ) only( Product 1 ) sheet =>some of the cells are linked to abstract sheet(which is fullfilled my requirement) there are 2...

i want to add IF condition in my macro.This condition need to merge in my code if E5= Random Value E6=Data List Validation (INPUT 1,INPUT 2,INPUT 3,INPUT 4) if E6=INPUT 1 ElseIf E6=INPUT 2 ElseIf E6=INPUT 3 ElseIf E6=INPUT 4 (CODE IS SAME ONLY FORMULAS ARE CHANGING IF INPUT 1 THEN THIS...

MyFormulas = Array("='" & wks.Name & "'!$BB$105", "", "", "", "='" & wks.Name & "'!$BB$109", "", "", "", "='" & wks.Name & "'!$BB$124", "='" & wks.Name & "'!$BB$143", "", "", "", "", "", "='" & wks.Name & "'!$BB$115+'" & wks.Name & "'!$BB$116", "", "='" & wks.Name & "'!$BB$211", "", "", "", ""...

With Sheets("Model") For X = 5 To .Cells(5, Columns.Count).End(xlToLeft).Column If Len(.Cells(5, X).Value) > 0 Then On Error Resume Next Set wks = Sheets(CStr(.Cells(5, X).Value)) On Error GoTo 0 If wks Is...

Hi guys, This is a very simple code, but I'm not sure why it isn't working. I want to loop through each worksheet in a workbook and make the same change to each: Copy a range and paste the figures into the first available empty row starting in Column C. At the moment, when I play this...

Hi there folks, I know how to press ctrl and select multiple sheets so as to apply something to all selected sheets. But I'm trying to do this in VBA My following code is supposed to copy the faux header (whatever the user selects, typically the first few rows) which often contains images and...