excel & vba 2016

Hi Gurus, Hope all is well. Is it possible to rename a file based on it's equivalent cell value and criteria? Scenario: I have different multiple files in a folder and in different file format Sample filenames in a folder 0001 Datasheetxx.pdf Dataaaaaasheetxx_002T.xlsx...

I have the following code but can't figure out why when I export the information to word and generate a "proposal" it opens the actual template. When the user saves the report it's saving it over the original document. Is there any way we can fix it so that word uses the template to generate a...

Hello. I have a code to find min and max dates in Range("A") and Range("A2") and a MsgBox displaying min date(in format number) and another MsgBox displaying min date (in format number). This is my code and works fine: Sub minmaxdate() Dim rng As Range Dim ws As Worksheet Dim ch As...

Hello I have a Chart in a Worksheet. In the Chart, I am trying to set xlPrimary axis and xlSecondaryaxis to none. I opened the workbook in Excel and made the changes manually with the Recorder on. This is the recorded macro code: ActiveChart.Axes(xlValue, xlSecondary).Select...

Hi, Everyone! I'm from Brazil and this is my first post. Sorry for start asking for help, but I already searched everywhere, without any solution for my problem. Maybe you can help me. The question is: I bought a software (with a large database), and its output is a simple Excel workbook...

Hi, I came across the following problem: I haven't got that much knowledge of programming, until this moment, I only made macros, using the record function in excel. This doesn't seem to work with the macro I need atm. Little explanation: The idea is the possibiliy of manually going...

Hi everyone ! Thanks to anyone affording time to read this and possibly help Here is my issue : I'd like to copy data from a filtered column, then paste it to a filtered column in a different sheet, or even a different workbook. I have a macro that works perfectly well to...

I have few shapes in the chart area populated by macros. I want to copy and paste the chart alone to the powerpoint while copying the chart. Is there a way to copy only the chart without the shapes? Many thanks!!

Hi all, I was wondering if i could get your advice, with the below error message and how can i go about fixing this issue on my Mac. I have searched high and low for a mac solution to a fix. this is the code thats failing: ExportWorkbook.SaveCopyAs ThisWorkbook.Path &...

In a workbook I have, I would like ALL sheets, except the sheet being used, to be hidden at all times. In the 'ThisWorkbook' Object I have applied this code: Option Explicit Private Sub Workbook_SheetActivate(ByVal Sh As Object) Dim MySh As Worksheet For Each MySh In...

Say I have the following table (A much smaller one than the one I actually have): <tbody> Japan Time RacerA 44 RacerB 23 RacerC 154 RacerD 17 RacerE 16 China Time RacerA 11 RacerB 165 Romania Time RacerA 11 RacerB 16 RacerC 19 RacerD 24 RacerE 130 </tbody> I want...

How i can insert a picture above another picture in excel cells in E column. E column cells have images in them.

Hi All, I found this problem and this is so serious! I'm using Excel version : 2016 for Windows So, when i have pivot table on a sheet, it'll render the all cells in the sheets can't be edited/inputted, see i was trying to type in E5, while the pivot table is in column M & N row 3. how to...

Good morning my peers, I was wondering if you could advise if there is a formula or VBA code that can be used for my issue. I have a database that once is filtered i would like to select the largest number in the filtered data of column G and populate cell a1. Is that possible by formula or...

I am trying to create a Excel VBA Macro to find bold text within cells with non bold text and add html bold tags around the original bold text and leave the non bold text alone. Example: Find: "This bold word" and Replace with: "This <code style="margin: 0px; padding: 1px 5px...

My excel sheet has 40 columns and more than 1,00,000 rows. I want to delete all the rows which contain cell with a string "NA" in any of the columns. I am struggling to find an efficient VB code for this on, which doesn't cause Excel to crash. Any suggestions? P.S. Exact number of rows and...

Hi everyone, frequent reader, first time poster. I have a question similar to that posted by user DougRobertson on March 30th. I have also noticed that Excel 2016 seems to open multiple instances compared with Excel 2010. So here is the problem I need to solve. My code opens another...

Hi Experts. I managed to find a vba to consolidate information from different workbooks into a single sheet but I need help to modify it slightly. I have X number of workbooks. In each excel workbook, I have lets say 10 sheets. This workbook is sent out to my team to fill up. In the master...

I m trying to speed up my VBA and I think it is because of the 3 columns that have foumulasin them. I am putting a forumula in cells B2(dl1), C2(dl2), D2(dl3) then autofilling to the last line my code is as follows /code dl1 = Application.Match("Deal #1", Rows(1), 0) dl2 =...

I am wondering if there is a way to search for a specific value in a column; then if the value is found highlight the entire row and copy it to another sheet or workbook. I know that you can do this manually, I was just curious if there was a way or writing a line of code or a string of macros...