vba macro excel help

Hi Genius, I need Little help regarding Merging cells with a button.. I am creating a Gantt Chart using excel formulas.. I want when i press a button, it Show me merge data according to below range. 1) B2:G2 2) B3:D3 & E3:I3 3) B4:F4 <tbody> A B C D E F G H I 1 LINES # 2/10 3/10 4/10...

I need help with my macro. I've got a table of data A1:R35 in sheet "Active" and when the value in column R is 100% and you press this button I want it to copy and paste that whole row into the next available row in sheet "Completed". Here is my current Macro: Private Sub...

Hi All, Please note:- I know about slicer but don't want to use and wants a vba macro only. Below is my query I've 3 pivot tables in same excel worksheet. All 3 pivot tables have 5 report filters and out of them 4 report filters are common. I want to use a drop down list from cell b4, b5, b6...

Hi There, I want to get a VBA code for checking if a particular cells has got any email address Suppose Cell A1 = abc then it should give error "Please enter a valid email address" and If Cell A1 = abc@xyz then it should let the user enter that value as it is a valid email address VBA code...

Want to Download All Company name from dropdown of below URL URL : "http://nseindia.com/corporates/offerdocument/recent_issue.htm" Trying below code but its not working Sub COMPANYNAME() Dim ie As Object Dim s As Object Dim sm As String Set ie = CreateObject("internetexplorer.application")...

I finally got my first VBA Excel macro up and running, but am having issues when using the *.xltm file I created.When I open Excel and select File>New>My templates and select my created template (called Resource Report Workbook), everything works perfectly...I get a new workbook opened named...

Hi guys! Im having some trouble here in setting a code. Let me show you what i've got: Sub procura() Dim lin As Integer Dim teste As String Dim teste2 As String lin = 2 teste = Cells(lin, 1) teste2 = Cells(lin, 2) While teste2 <> "" teste = Cells(lin, 1) teste2 = Cells(lin, 2) If teste =...

Hi, Would like to convert values in cells within a certain column. The column must be selected by it's header name "wyarctick_contactID", due to the fact it's not stationary (likes to move around). I thought maybe defining a range(all row 1 cells) and then stating "if...