Complex VBA – Trying to use specific online calculator and download data to excel

Hello, I am new to Excel VBA and would appreciate if someone can help me to find the solution to the problem. I have an excel sheet with some specific values, and I would like excel to open the Continue reading Complex VBA – Trying to use specific online calculator and download data to excel

VBA code to print unique values and corresponding values from the other coloumn

Hi Members I am stuck at a situation. I have a excel sheet with two columns. Column A has Departments and Column B has corresponding “employees”. This sheet is named as IN sheet in all the excel files. There Continue reading VBA code to print unique values and corresponding values from the other coloumn

[SOLVED] change from vba code (const as date) to (cell.value in worksheet)

Hello,I have one new issue. When I’m trying to change to cell value I’ve got Global Error. Const FirstDay As Date = “2017-12-31” to something like this: dim FirstDay as string FirstDay = Sheets(“DATA”).Range(“J3”).NumberFormat = “yyyy-mm-dd” Thanks Continue reading [SOLVED] change from vba code (const as date) to (cell.value in worksheet)

Counting Number of Colors in a sheet (not Number of Colored cells)

Team,i’m trying to count the number of colored groups (how many colors groups not how many colored cells). Appreciate any help or guidance on that request?note: its a huge database, and my example below is just to explain my Continue reading Counting Number of Colors in a sheet (not Number of Colored cells)