Solved

EXCEL VBA CODE

Posted on 2014-02-25
3
428 Views
Last Modified: 2014-02-26
Hi

How do I write VBA code for this please:

Domestic<space>Airlines<Alt+Enter>LIST

(note: it could have a space after the word Airlines if necessary)

Many thanks
0
Comment
Question by:GAILBAKER
  • 2
3 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 39887771
If you are trying to write that to a cell:

Range("a1") = "Domestic Airlines" & Chr(10) & "LIST"
Rows(1).AutoFit

Open in new window

0
 

Author Comment

by:GAILBAKER
ID: 39887993
Many thanks Patrick - it worked:

Sub X()
'
' X Macro
'

'
        Cells.Find(What:="DOMESTIC AIRLINES" & Chr(10) & "LIST", After:=ActiveCell, LookIn:= _
        xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:= _
        xlNext, MatchCase:=False, SearchFormat:=False).Activate
End Sub

Best wishes, Gail
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 39888685
Glad to help :)
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now