insert text

Dear all, I am trying to input text into a webpage and search and am running into problems. Below is my code Sub GetHTMLDocument() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput As MSHTML.IHTMLElement IE.Visible = True...

Hi, Thanks to PGC01 for the below code to show where page breaks are on a sheet. I was just looking to edit the code so that rather than the message box appearing it actually puts the text in the row itself. Something like "There is a page break on this row" in column A would do the trick I...

Hi, Thanks to all the posts on here I have been able to copy, paste, butcher and fudge my way through to almost what I need. I have a sheet with multiple columns with a list of sites which we may visit to carry out a Test, service, Repair or any combination of the three. <tbody> Site A...

Hello! Firstly, thanks for this forum. This is the first time I had to register and post my own question, but I've used your site to figure out a dozen problems I had before. I'm going to start with the end-state im looking for, but if anyone can provide just one piece to this puzzle it will...

I have a table for the month with dates on one row, amount of calls reviewed per day on second row(row2), hours Worked on the third row(row3) and each column has a fourth row which. does an average of Row2/Row3. at the end of row2 and row3 it sum the totals. on certain days my reps have PTO and...

Hi I am trying to insert text from cells in another worksheet as follows: I have a front sheet named "Front Sheet". Column A is already populated with a list of company names. Column B is for Contact names, Column C is for email address. Each company has its own worksheet, and is named as...

I have a column where each cell contains a word or phrase. I want to be able to insert a word in each cell of that column before the text that it already contains. I would also like to be able to insert a word after the text the cells in that column already contain. A2 "marketing" A3...

I'm setting up a form for people to enter information into. I have a free-form text field that users need to be able to type into, so I can't put a formula into it. However, I want a value to be "injected" into it upon a certain condition based on a formula from another cell "watching" that...