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
Hi there, I am very new to VBA and I have a problem that I know VBA can help me with but I can’t figure out the coding. I Continue ReadingVBA Code help – Search files within folders and return file name and path
Hey! I know that word does not really “understand” how pages work, but lets say that at the end of every page there is a page break. If this Continue ReadingMerging/deleting duplicate pages?
Hi All, Relatively new to VBA in ppt 2013, have previously only used in excel. I have a template presentation that I need to replicate 100 times for different Continue ReadingReplicate template presentation with list of names in excel
This post started off as a query, but I have since resolved most of the issues … however … I have a collection of macros that are being used Continue ReadingVBA, Style names, Find-Replace Special Character Codes, and non-English versions of W
I have a collection of macros that are being used by a friend in the Netherlands who is using the Dutch version of Word on English language documents that Continue ReadingVBA, Style names, and non-English versions of Word
