Search:

Alan -Thanks for your help and detailed explanation

Hi Alan

Thanks for the help

I need two small changes

1) I need the csv file to be saved to "C:\Journal Templates" -(have amended this in the code)
2) I need the sheet name to be the same as...

Thanks for the help Alan. I need one small change. The sheet name is now correct, but I need the original workbook name i.e Adjustment JNL.csv

Kindly amend your code to incorporate this

I have written code to create a csv file, but the sheet name must the same as sheet1 on the xlsm file from whch it was created



Sub CreateCSVFile()
Dim MyPath As String
Dim MyFileName As...

Thanks Scott, The diagonals, slow down the process tremendously

Have tested code and is super fast

Thanks for the help, much appreciated

Thanks for help, much appreciated

I have added the following code to clear the borders at the beginning of the code.

It would be appreciated if you would streamline this


With Range("A:D")...

My apologies for not showing the link to the crosspost

Problem now resolved

Hi Alan

I added "On Error resume next" to mey code and it now works

Have managed to sort out the code, but want to exit code after finding "DEPR" one row below DEPR-GENERATORS, the macro must stop, otherwise Insert "DEPR" in front of the text five rows below, but...

I have a workbook with several sheets and want to find "DEPR-GENERATORS" in Col B and insert "DEPR in front on the text from one row below to 5 rows below

This must exclude sheets "Data",...

Hi Alan

Code works perfectly where there are several columns next to Col A where the text is in bold

I have another sheet where there is only one value next to the text which is in bold and I...

Thanks for the help, much appreciated

Thanks for the reply

I did use a macro recorder, but not sure how to have the thick Border Box aroond the values in the same row where the text in Col, A is highlighted
I have attempted to write...

I would like a think border box to be automatically inserted where there are values to the right of text which is in Col A and the text is in bold

For Eg if A15 "Net Profit" is in in Bold and...

I have the following code which is used to open up workbooks one by one and to update these . The source workbooks in CSV format are in the folder C:\downloads. However, I need to open each file...

Hi Excelfox

Thanks for all your help

I managed to find the error.


If InStr(.Range("B10").Value, "MENS SHOES DEPARTMENT") < 0 Then

This should be

Thanks for the help. Where Mens Shoes Department" appears in B10, Rows 2:8 are not being deleted

See sample per link below

...

I have the following macro below

The macro is working well except for the code to delete rows. Rows 2:8 must only be deleted on those sheets where "Mens Shoe Department" appears in B3 , except...

I would like a macro to clear data on all sheets except formula, text, items in bold, values to the right of "GP % target" (the text appears in Col A and the values in Col B:M) and data that has been...

Hi Guys

Thanks for the pointers in the right direction

Thanks for the info. I think the best option would be to use datepicker add-on linked to the combobox. It would be appreciated of you could assist me in writing code to activate the datepicker or a...

I have a user form containing various fields and would like code that forces the user to enter a date in the date field on the user form called called "TxtDate1" in the format dd/mm/yyyy. If not in...

Thanks for the help, much appreciated

Thanks Bakerman for amending the code. The macro works perfectly