excel and vba

Hello all, New to the forum so if there is a thread I can read that is already established, happy to view it. However, I am attempting to use VBA to send code from a submission spreadsheet to another log of the data. Currently the code works, however, it is copying the formulas and not just...

I routinely get files and people here have helped me with automating one component. However I wanna create a macros that allows m to automate the updating of certain worksheets. I am given an excel file with three tabs. In the first tab i get a lot of hospital data and one of my tasks is to to...

Hi, I am creating a new excel Addin and i have added some macro to it, when i am trying to add it to the excel with Normal procedure it is not appearing in the data Ribbon of the excel, and i have added the Addin location to the Trusted location option, please kindly help with this, i am not...

I have tried a number of different variations to copy and paste but they are not working. I keep experiencing a run time error. Sub Filter() Dim Wkb As Excel.Workbook Dim ws As Sheets Dim i As Long Dim LastRow As Long Dim LastRow1 As Long Dim Rng As Range Dim deleteRange As Range Set...

Running into problems with indirect functions and apostrophe's in a sheet name. have 30 files with ~10 sheets each - maybe 10 of the sheets total have names with an apostrophe in it. Is there a way to run through the sheet names of a given file and remove certain characters (like, say, an...