?
Solved

EXCEL VBA CODE

Posted on 2014-02-25
3
Medium Priority
?
463 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 93

Accepted Solution

by:
Patrick Matthews earned 2000 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 93

Expert Comment

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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

621 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