address

good afternoon all. i have a vba program that populates text/list boxes on a form, based on a users request in the form. it reads off a excel sheet that has delivery information for fedex shipments. the cells that contain the delivery "street address" are giving me an issue because they...

I have an address that is in one cell formatted with: Name address address2 city state zip There is a hard tab (alt tenter) between the lines after the first line. (the bolded lines) I need to keep everything in one cell, and add five spaces in front of each line. I need to be able to do this...

All, Trying to use lookup and address for the first time and think i am doing it wrong. SUMPRODUCT(--ISTEXT(address(7,LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))):LOOKUP(address(7(2,1/(G5:G15245<>""),ROW(G5:G15245)-300)))) So i have a ton of stuff in coulmn G I need to find the last value that...

I've run into a little speed bump in some code that is trying to access a named range of data using the name of that range, rather than the range itself. I know some will argue against doing that, but let's leave that aside for now. To illustrate the problem, I wrote the two little test UDFs...

Hi All, Looking for VBA code which helps in finding a value in list of files in the directory. It should fetch the filename, sheet name and address of the cell where the value holds. For instance if I want to search "December 2019" in directory which has files name say file1, file2, file3...

Can you please help me with making this happen? 1.) Just to keep this simple...Here is the raw Data from Excel (These cells are formatted with boarder lines surrounding each cell) PO Date Po# Vendor Provide Tracking# Vendor Email 3/15/19 WZ-54244-P NISSAN tracey.noe@abc.com 2/12/19...

HI Folks.....Just a regular Pool Service guy here....Looking to use Excel to maintain Route Sheets. I want to have one sheet that has a long list of customer names, address, and other things...and be able to populate a single template when I print them out. The template will have the names...

Hi, I have a list of business names in Excel starting in cell A2 going down to A3, A4 etc. The record-set is pretty large as it contains over 100,000 rows. What I need to do is to retrieve the address for these business using IE and return the corresponding address in cell B2, B3 etc.. I'm...

Good Day I m trying to capture MAC Addresses on computer onto a user form. When capturing the NAC Address the cell is returning a value of True whereas I want the cell to display the MAC Address. My code is as follows: [CODEws.Cells(iRow, 40).Value = Me.TextBox77.Value =...

I don't know if there is a way to do this, but i suspect that someone may have had this need My column A represents "Complete Address" Column B is the "Number and Street" Column C is the "Dock" Column D is the "City" Column E is the "State" Column F is the "ZipCode" I am trying to make column...

Hi Guys, Could someone help me work out the script or formula to index these columns and create new rows with the names in different columns? This data columns containing names address and address turns into address with rows of names -> <style type="text/css"><!--td {border: 1px solid...

Does anyone have a canned Excel formula that will check a cell to confirm it is a properly formed email address with no extra characters or blanks? In cell A1 might be: name@domain.com first@anydomain.org or any similar properly formed email address Formula in cell B1 would return FALSE In...

I am trying to extract email address from columns and display them in another column. The way the information is extracted causes the email address to appear in columns. Example: A

Hi there, I currently have an INDEX MATCH formula which is working across 2 spreadsheets and returning the value of the cell I want it to, but I want it to return the reference of the cell instead of the value it contains. I keep getting different errors when I try to use the address...

Consider the following two formulas for calculating the last row in a column and last column in a row: Formula for calculating last row in a column: =LOOKUP((2), ((1)/((E:E)<>("") ) ), (ROW(E:E) ) ) Formula for calculating last column in a row: =LOOKUP((2), ((1)/((5:5)<>("") ) ), (COLUMN(5:5)...

Hi, I want to Do a VLOOKUP Based on the Data in ComboBOX1, ComboBox 1 Data Is in Table 1 Column A , I Want to look up the value/cell address of say Column D , then once this has been done Replace the Data with the Contents of TextBox1.Text. Is this Possible? Kind Regards, Tom

Hi, I am importing data from a text file into excel. Unfortunately the text file has stacked columns, so what would be the best way to convert the data from this: <colgroup><col span="2"></colgroup><tbody> Name Address Number Zip John 1234 St. 1111111 44444 Mary 5678 St. 2222222...

Hello! I have a line of code Range("A1:LastTableCell").Copy Worksheets("PasteSheet").Range("PasteToHere").Value This keeps giving me an error, and I'm guessing it's because I'm using variables. LastTableCell and PasteToHere are both variables that contain addresses. For example, LastTableCell...

Hi, I have a mail merge like script in excel vba where the macro will go through list of e-mail address, attaches and attachment and drafts an e-mail. When the e-mail is drafted, there is no hyperlink on the last line of the e-mail (which is an office address) but when it actually gets sent...

Hi, can anybody help me with task to check if email address is correct? I dont mean format, but if it bounces without sending an email. There are online services to do that for some price so it is possible to do it somehow(they were correct for my company mail, personal mail, gmail etc.). So...