Forum

Hi Sherry, A few tips: Range(Cells(Target.Row, 27), Cells(Target.Row, 27)).Value is not the right way, as both ranges point to the same cell. Ju...

Hi Nick, Can you please clarify why the item below should be 1? That seems to be occupied in your example? 1044220 7560000 Should be 1 ...

Hi Daniel, Welcome to our forum. Can you please upload some sample file so we can see your data structure? There can be many ways to get the res...

Hi Jingjing, If you have a table with DOI strings, add a new column calling a custom function (built based on the sample query and pass to the func...

Hi Mani, Have you tried the code provided in your other topic? Should be very similar.

Hi Mani, Instead of writing complex codes, try the solution attached, all you have to do is to refresh the Report if there is new data in the sourc...

To Insert (copy) a shape from a file to another: Dim Pic1 As Shape, Pic2 As Shape, Sh1 as Worksheet, Sh2 as worksheet Set Sh1 = SourceWorkboo...

Hi Pieter, Here is my version of the query: let Source = Excel.CurrentWorkbook(){[Name="tblRawData"]}[Content], Roles = List.Buffer(Excel.Curr...

Hi Phillip, There are multiple ways to set a timeout: driver.Timeouts.ImplicitWait = 5000 ' 5 seconds As well as individually : driver.F...

Excel is not meant for image processing. Use javascript:

Hi Zara, Yes, it is possible. Is there a reason for doing that with a macro instead of a simple conditional formatting for that range?

Hi Gob, I'm afraid it's not possible, there is a sheet Change event but this event detects any change, it cannot make the difference between a manu...

Hi Glenisa, Hard to imagine how it should look, can you upload a sample file showing the before and after versions? thank you

Why not use a pivot table, instead of manually splitting data into tabs with formulas? You can use sliscers to filter data for a specific Region, or y...

Hi Damian, That formula does not work with a range of cells. All you can do is to use vba to convert the range to HTML, this is the format accep...