vba & macros

Hi there, I know very little about VBA, only starting using it this week by copying from Google, so my understanding of it is very small. I've been searching the net for a solution to my problem, however given my lack of understanding of VBA, have not been able to decipher solutions on Google...

I want to copy the contents of cell A5 to the bottom of a list that begins at D10 of the same sheet and goes down that column as new values are added to the list. For example, if the list now extends to D18, I'd like the value currently in A5 to be pasted to cell D19. At a subsequent time I'll...

'******* EmpFolder is a Global Variable containing Folder Path ************************* Sub BatchConvertDocxToPDF() Dim objDoc1 As Document Dim strFile As String, strFolder As String 'Initialization strFolder = EmpFolder & "" strFile = Dir(strFolder & "*.docx", vbNormal)...

Hi guys, i need help. I have a task and i dont want to use vlookup because it makes the process very slow. im looking for a purely VBA code for the task. here is the code: Sub get_current_status() Application.ScreenUpdating = False Sheets("Sending List").Select Dim Lastrow1...

Hi Gurus, I'm currently working on a macro but can't find any that suits the process I have. I need to rename hundreds of files in word, excel and pdf format. Example Filenames: HOP12345 FileOne.doc 9876ABCD FileTwo 1234.xls A1RBL234 Data 000.pdf What I need is the macro that will rename...

On sheet one I have event dates in column C starting on row 7 and ending on row 105, event names in column D starting on row 7 and ending on row 105, and event type drop down in column F starting in row 7 and ending on row 105 with a color coded fill that changes with event type in column E...

Hi Team, I want to extract outlook emails data in excel using VBA according to specific words in subject of email. The subject of emails keep on changing but some part of the subject remains same of all the emails. eg. My email Subject is "Prod - Work Daily Alert for user Steve Johnson...

Hi all. I have two private subs, they work when i run them alone but i am having trouble combining them The function of the code is id you select a value in d15 it would unhide rows depending on the value so select the number one and it hides the 14 rows below Then move onto d16 and the axact...

Hello, I am making a form. I have a checkbox1 and checkbox2. I want to make it such that whenever checkbox1 is checked then everything already entered in textbox1, textbox2 and Listbox1 is automatically deleted. So I want to have the above controls blank when the checkbox 1 is checked Please...

I have a series of addresses that are in the following format: 273 Winding Road Boyertown OH, 19512 16 Penn Lane Wayne PA, 19087 519 Conshocken State Rd Happy Valley PA, 15208 What separates the city from the address line is two spaces. I'm trying to figure out how to pull the City, State...

Hello guys, i am working on project where i need vba code to click on "Add Filter", code here looks like - <div class="select-filter-field no-filters" ng-class="{'no-filters' : currentOptions.length === 0}" ng-click="addFilter()"> <i class="fa fa-fw fa-filter"></i> Add filter...

Hi Guys, Firstly I'm really sorry if this question has already been asked, i did have a really good rummage and couldn't find anything. i have a column that I enter a code in (lets say E4), which is the one i want to conditional format. I want this to be linked to a different cell that...

Hi All, Please help me solving this error. I have read several post on this error but still I am unable still unable to find solution. This error occurs since below array formula have extended more than 255 char. Please help me how should I break this formula to make my code work. I am using...

I have three sheets - PO, SBI, Query We will use the following fields to identify any matches from the Query tab. We should be able to add a list of data on the Query tab, click the “Run Query” button and automatically check if these entries are in the POD or SBI tabs or not, returning a...

I have a VBA code the hides columns based on 3 different cell values, but it is not working properly. If cell Z7 & Z33 do not equal "Black" AND if cell Z39 does not equal "Yes" then hide columns K:N. So I want the code to hide columns K:N if Z7 & Z33 <> "Black" and Z39 <> "Yes". Sub...

Hello All, Greetings for the day! I'm having a VBA script which works absolutely fine when run manually. However when I tried to run it through windows Task Scheduler, few codes of this script not executing and hence not giving desired result. Any idea for this paradox? If required, I can post...

I volunteer for my local scout group and wish to create a report that shows which badges have been completed, which are in progress and which have not been started. This is to make building a program easier as we can see what badges to work around. Currently we use a system that allows us to...

I have a spreadsheet that survey's equipment condition for equipment condition for multiple places, which is designated by ID (see Data Input example). For each row I need the equipment under the columns header "E1" and "E1C" copy/pasted into another worksheet ("Data Output") with the ID number...

Hi all I'm wondering if you could help or at least suggest options. I have looked through loads of threads and have been able to add rows using a message box but I need to then autofill them cells added with a sequence. Sub MyInsertRows() Application.DisplayAlerts = False...

AC AD AE AF AG DWG. NO SYM. FS991EX MB4250 I am a newbie in VBA The thing is I need to compare two columns of two sheets. My biggest problem is that sheet2 is always changing (new sheet2 will be inserted every now and then) so the column position is also varying. I...