mybook

Hi Everyone, So I was wondering if there is a way to reference thing like sheet names and ranges outside of the macro and still have it know what I mean? for examples This is an example of how I might currently write a macro (I know its not real its for example only) Sub Example1() Dim sht...

Hi Friends, I need to update a common value i.e. "123456" in Cell H1 of Worksheet name "Index" of all excel files which are stored in a folder. The folder also has sub folders. I tried using below macro, however it is not updating files in folder and sub folder Sub Example() Dim MyPath...

I have code that is supposed to add price changes to current price values for all workbooks in a certain file location but I am having trouble getting it to work. Sorry, am a VBA noob. Here is the code: The BOLDED is the line that is giving me issues. Sub FactorChange_Price() Dim MyPath...

I have file MAIN.xlsm with Macro and two sheets "A1", "A2". When I Press "Get DATA" button I want to copy data from sheet "G000141" into "A1" and sheet "G000142" into "A2" (G000141, G000142 from another WB) plz help do that, this's my code but it's not working. Sub Ngoai1()On Error Resume...

Hi, I have the codes which can split the data into new worksheet, but it is not considering the header while doing this. can anyone help me to solve this. Sub test() Dim lastRow As Long, myRow As Long, myBook As Workbook lastRow = ThisWorkbook.Sheets("Sheet1").Cells(Rows.Count...

Hi, I have a folder with many workbooks, they have the same number of sheets, one of the sheets is named "Bank" and is protected I want replace "Bank" sheet with a sheet in an active workbook named "BG", but the copy code is not working. This is my code : Sub Example() Dim MyPath As...

I use the following code to loop through all the excel files in a folder and bold the header and then subtotal the results. The issue is the number of columns varies as this is a daily report and I am unsure how to change the TotalList:=Array(4, 35) to a variable that will find the number of...

Dear all, I have a VBA code which allows me to update cell formula in all folder's file but the formula returns "TRUE" instead of value PS: the same formula works manually. This is my code : Sub Example() Dim MyPath As String, FilesInPath As String Dim MyFiles() As String, Fnum As Long...

I have the following script in my spreadsheet that loops through a folder and then applies bolding and subtotals to each spreadsheet within the folder. With the reports containing information by day, the number of columns to subtotal will be different each day. I am wondering if there is a way...