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 Continue ReadingComplex VBA – Trying to use specific online calculator and download data to excel
Hello, So I have VBA code to reply to a normal email with attachment, but I need help to modify the code below so that it can also work Continue ReadingOutlook 2016 – VBA Macro for replying with attachment in meeting invite
Compare 2 Sheet and by 2 column and compare date get the value on sheet 1 Compare 2 Sheet and by Continue ReadingCompare 2 Sheet and by 2 column and compare date get the value on sheet 1
Hi All, I am not sure if this is possible, I have a macro where the user only uses User From and excel is just a means to open Continue ReadingVBA not to show excel file, excel logo, excel ico but only show a User form
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 Continue ReadingVBA code to print unique values and corresponding values from the other coloumn
please tell me where is problem. thanks Code: Sub test() Dim mysheet As Worksheet Dim lr As Integer Dim selrow As Integer Dim cat As Integer Dim x As Integer Continue ReadingVBA code help 2016
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 Continue Reading[SOLVED] change from vba code (const as date) to (cell.value in worksheet)
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 Continue ReadingCounting Number of Colors in a sheet (not Number of Colored cells)
Merge specific worksheet from multiple workbooks into a single worksheet Merge specific worksheet from multiple workbooks into a single worksheet Continue ReadingMerge specific worksheet from multiple workbooks into a single worksheet
Hello, I have been working on a spreadsheet within which I have an auto email on Worksheet_Open which sends out a reminder email based on the date field falling Continue ReadingVBA code to delete contents of one cell based on change in another
