HLOOKUP() Function - Introduction

Hello Forum,

This is Krish, I am new to this forum.I am having some doubts in VBA. how to address those in this forum. can any one please help me ?

regards
Krish

I have a user who somehow managed to have excel display a box below the subject line labeled 'Introduction:'. This box is below subject and above the formula line. Does anyone know how to remove it? I am stumped

Hi Everyone,

I am Kynthia Melissa, a very new member to this forum. I have a special interest in Computer software packages.My approach is to enable the visualisation of complex data in a simple way.I found this forum very informative and I am really very excited here to take part in discussions. Hope you will contribute your ideas and support me in my mission.

Thanks & Regards
Kynthia Melissa

Hi Everyone,

I am Kynthia Melissa, a very new member to this forum. I have a special interest in Computer software packages.My approach is to enable the visualisation of complex data in a simple way.I found this forum very informative and I am really very excited here to take part in discussions. Hope you will contribute your ideas and support me in my mission.

Thanks & Regards
Kynthia Melissa

Hello All!!!

You have put together a very nice forum here. Certainly the result of a good community.
So on behalf of all the wannabe VBA coders, THANKS!!!
I'm currently learning VBA. I'm good with basic code but now want to take it to the next level: Designing ROBUST (unbreakable) utilities for the engineers I work with.
So here I am!!!


Attached is the latest utility I created but it has a number of issues:

1) Placing "X" in plot row does not seem to be intuitive for most of the engineers, I'm planning on replacing it with check boxes or depress-able buttons.

2) To hold the plot format/layout; I have a white line so that when no data is plotted, the chart remains. Thus, starting the data at serriescollection(2). I would like to go to a cleaner solution where the macro generates the entire chart, on a new sheet (named according to chart title), with the format/layout as shown generated with code.

3) If you delete the chart key, it will crash the macro when run again...... should be solved with issue #2

4) I want to macro to consolidate key titles; if there are multiple insistence of the same legendentry() --> consolidate to one.



Any help or reference to examples would be greatly appreciated. I want to take on issue #2 first.
Feel free to clean up any sloppy or in-efficient code and post up your revision. Add lots of notes in the code for the beginners =-)
I hope to be a strong member of the forum and plan to contribute lots of examples code similar to this file ;-)
With the help of the experienced members on the forum, these can become very nice examples beginners can easily learn from.

Peace Out,
-Aaron


Searchability: plot data, color lines based on text color, plot data based on cell marker

I have decided it is about time I learnt to use VBA properly. Can anyone point to a good introductory guide? Either online, or a book.

Thanks
Bert

Hi all. I have a sub which pastes an xl selection to word and then calls an email dialog with the word doc as attachment. This is fine but I would like to code into this an introduction tp the email. Any ideas?

This is my code:



Option Explicit

Sub PasteToWord()

Dim AppWord As Word.Application

Set AppWord = CreateObject("Word.Application")
AppWord.Visible = False
Application.ScreenUpdating = False
Sheets("GOQ-R").Range("A1:I275").Copy
AppWord.Documents.Add
AppWord.Selection.Paste

Application.CutCopyMode = False

AppWord.ActiveDocument.SendMail
AppWord.ActiveDocument.Close SaveChanges:=False


Application.ScreenUpdating = True
Exit Sub



Set AppWord = Nothing

End Sub

Hi,

I've made an Introduction to SQL tutorial aimed at Excel users.

I would love to hear feedback on how to improve the tutorial, especially
if you are an Excel user without much existing SQL knowledge.

http://www.querycell.com/SQLIntro.html

Cheers
Sam H

Hi all

I often use VLookUp tables, however, I've never used HLookUp.

Is the only difference between them the way the data in the table is
displayed - either in columns or rows?

Thank you.

Louise

I've created an array table with ascending data. I've labeled each row with a specified integer representing length and want to specifically look at a particular row for the closest matching data using HLOOKUP. In the right most column, the first data from top is greater than my minimum search criteria, hence the result returns #N/A. I've created a second statement to correct this when the result = #N/A but cannot seem to tie it to the HLOOKUP function. Any suggestions how to write IF(HLOOKUP)=FALSE,THEN(2ND NON-HLOOKUP FUNCTION)?

HLOOKUP is: =HLOOKUP(BQ4,BK108:BK111,BR4,TRUE)
Where BQ4 = 260 120 & BR4 = 1 (statement created to figure row_number)
2nd is: =LEFT(CG4,(SEARCH(" ",CG4))-1)+1&" "&RIGHT(CG4,(SEARCH(" ",CG4))-1)+1 where CG4 = 208 101 (result = 209 102)
BK108:BK111 = 282 132; 308 150; 337 172; 370 198

Thanks in advance for all suggestion.