vba ''

i want ONLY buy and sell price in excel from https://bx.in.th/ Is there any <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial...

Hi, I have just recorded the below macro to go through and select each account number on a pivot table filter. I was just wondering if anyone knew any code that would do the below for all values in the filter instead of me going through and recording it ac number by account number? the...

Hi all I have 100 tables to import in a logarithmic graph designed in the same sheet of the tables. After recording the macro I had these lines: ActiveChart.Axes(xlValue).MajorGridlines.Select ActiveChart.Axes(xlCategory).Select ActiveChart.Axes(xlCategory).ScaleType = xlLogarithmic...

Hello, I'm wondering how to copy data in the next blank cell within a set of rows? I know that this will copy data into the next blank cell of the entire column A .Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial But I want constraint that to just a certain set of rows in that column...

Hi, Due to compatibility issues, I am having to use a form control listbox (vs. ActiveX) control on my spreadsheet. I am trying to populate it with three fields from an ADO recordset, but I am having problems as it has been sometime since I have used Form Controls. Here is the code I...

I have a Master file which monitors shipment progress for my company. I update this on a weekly basis with progress on existing shipments (shipments which are already in the master file) and input new shipments. These updates come in the form of a update sheet which is in the same format as the...

Hello, I am trying to be able to better identify shortages without as many steps for other users that are not as fluent in excel. Currently, all I do is take my sales order filter down to 3-4 weeks and run a combination script: Sub CombineRows() 'Updated 20150511 Dim WorkRng As Range Dim Dic...

Dear Experts, I wish to know how can I split a paragraph in different cells - one below the other. Catch is when a sentence ends with a full stop and space, question mark, punctuation mark or tab, the next line should appear in next cell. Also, the numbering should be altered as shown in...

I want to find a specific text in range, if that text is present in a range then output should be yes else no <tbody> A B C D brands Keywords output should be Reason Papermate Papermate pencil Yes coz it contains Papermate (Present in column A) HP Papermate pen Yes coz it contains...

Hi Guys, I get an invalid Next control variable reference for the below code, please advise Sub TRP() Dim X As Long Dim Y As Long For X = 1 To 32 For Y = 1 To 32 With Workbooks("TB.xlsx").Worksheets("XM").Range(Cells(112, X + 2), Cells(112, X + 4)).Copy End With With...

Hi, I have a Excel spreadsheet with hostnames in column A. I have added this macro so that I can doubleclick to launch Putty to log on a given host: Private Sub Worksheet_BeforeDoubleClick(<wbr>ByVal Target As Range, Cancel As Boolean) If Range("A" & ActiveCell.Row) <> Empty Then...

i want to create a customize ribbon for workbook specific. so that i can use this ribbon for only that workbook where i created. is there any way on excel 2010. to do this?

Hello, I need your help in rectifying the code. This macro goes to certain columns, highlights the errors in magenta, creates a sheet and paste those errors there and also initiates a spellcheck. But I am receiving an error "Checkspelling method of range class failed". Here is my code: Sub...

i have a sheet with a hundred check boxes. Can someone help with a VBA script to assign the same macro to all checkboxes on current sheet?

Hi I'm not very familiar to VBA. I've done some very simple scripts but I can't figure out how to do this. I have a table and in column J, the cells can be empty or have a value from 0 upwards. If the value is >0 then I need to color cells in the same row and columns L to P. How would I do this...

Hello I am looking for VBA to copy the first row in a named range and paste it to whole of the named range. I am sure its very easy but I cant find anything. Thank you tttommy2

Hi, in Excel I'm using formula: A2 = REPLACE(A1,1,FIND(":",A1),""). Now in VBA I did like: ws.Range("A2").Value = "REPLACE(A1,1,FIND("":"",A1),"""")" and it's ok. How can I directly assign value from formula to my variable??? I had something like below but is wrong :/ Dim new_value as...

Please Help, I need help inserting Text that would say "Total" under each product group and Auto Sum for each group of data in the next column Thanks <COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY> Apple 3 Apple Apple 4 Apple Apple Total 7 Orange...

I have a database I created in excel. I use VBA to open a file and copy the data then paste it into the database. When i later plot the data and view it i have an issue with "0" values in the excel cells that should be blank, empty, null whatever you want to call it. This piece of code selects...