vba & code

Hello All, New to this forum as well as VBA, so i would appreciate some insight. This is probably a simple fix, but i am not able to solve the issue. I have received the following error for the code in the module i am building. I have tried simple fixes ( adding and removing paste, changing...

Hi since i updated my code the error 70 "Permission Denied" keeps me from activating my search form. Const SEARCH_BLANK As String = "[BLANK]" Sub FilterData() Dim ws As Worksheet Dim i As Long Dim lastRow As Long Dim matchCriteria As Boolean ' Change "Sheet1" to the...

I am extremely new to VBA, so I hope that this is easy to do and I am just missing the obvious. I have code that defines a named range as the active row, and another that does the same for the active column. How to I combine the two into one sub so that I can automatically calculate active row...

I am new in learning Userform VBA code, I created a Userform having labels,textbox and multipage with ClsTabMenu,Module1 and Userform Codes but on clicking run to load on VBA home, it displayed Run-time error "91" Object Variable or With block variable not set find codes below clsTabMenu...

Dear, I have an excel file that have an expiration date, and I would like that when the date is -15 days before expiring it send an email automatically based on some cells information to the outlook email once the system logged in. I have add a code but it is not sending auto email and I have to...

Hello all I have the following VBA code Sub Create() Dim application If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(Connection) Then Set Connection =...

Hi I need help about vba macro, The thing is if any cell in column "c" has web link, it will be spared all other cells would be deleted (shift cells up) Just this is my required! Now I do know vba, but not that much to be able to write a code by myself so if any friend could help me here...

Hi all, Need an urgent solution to the below please, if possible. It is beyond my VBA capabilities. I have created a new Excel workbook and inserted a macro button name "Import NC Data". What I need the macro VBA code to do it to ask me to select / specify a specific folder (folder and...

Hello Everyone. I will truly appreciate your help. My aim is HTLM text from column A to be copied in column B as normal text, after each word "см" i would like a new line(enter) to be created. That operation should be done via VBA code. Many thanks in advance for your cooperation. AB1Copy...

I would like the following code to create a duplicate window, tile these windows vertically, follow the reference from the originally selected cell, then select this cell's referenced cell in the second window. Everything seems to be working correctly until the last line of code where it will...

Hello all! Hoping that someone could help me or even tell me if this is possible! First time poster but have been looking at posts in the forum for a long time! Column B - I have levels that have a code assigned to them based on column E, and column G are my expected results. If the level...

Hi Guys, I need your help, Please note I am trying to use the value from a Textbox (Have a formula an extract a cell value (number with format as percentage) to convert to integer or number in order to proceed with a condition to determine if the value is X1 < 0 , X1 > 0 or X1 = 0 (This part...

Hey everyone, I have a macro that checks to see if the excel file open is the latest version for my technicians. I am able to successfully check, download have it rename everything. But once I get to the Kill it gives me the good ol' You don't have permission to delete that error. I have posted...

Hi hopefully somebody can help. Using Conditional Formatting I've built a workbook which checks for a number in a series of columns on one worksheet and if it finds a it in a grid (named range 'Grid'), formats the cell to a particular colour. This works great, but I have 150 CFs so the whole...

Hi, I currently have 2 steps of code which work fine but I want it to work off of one button press to take the data from one workbook to multiple other workbooks and save as per the name. The first set of code filters it but puts them into sheets and the second set of code converts those sheets...

I am trying to Copy from 1 workbook (S.xls) and pasting into (PD.xlsm). However I also get the same error 1004- Application-defined or object-defined error at this line "lastCol = sh1.Cells(1, Columns.Count).End(xlToLeft).Column" Sub Rectangle1_Click() Dim sh1 As Worksheet, sh2 As Worksheet...

Hi All, Please note I already have a code that works but I would like to do it faster. Dim X1, X2 as worksheet Set X1 = Sheets("DataBase Hierarchy") Set X2 = Sheets("Tool") X1.Select ActiveCell.Offset(0, -1).Copy X2.Select ActiveCell.Offset(0, 1).PasteSpecial xlPasteValues...

I'm having an issue with getting the MACRO to copy from the correct sheet when it is taking data from another excel work book. The issue is even though I have the sheet search on for the "TOP" it will copy form which ever sheet was last active when the excel was open. I currently have it set up...

I want to filter and split the data based on branch name (Branch List sheet), and also want to save that new excel workbook for each branch as per the same name as mentioned in the Branch List sheet. Please help me with LOOP function to complete my code.

Hello! Thank you in advance for visiting my post. I understand there have been a couple posts here already that ask for help regarding VBA code and moving data from one sheet to another based on a drop-down value, I appreciate your help nonetheless. ---------- We are approaching territory...