creating a sparkline using VBA

Hi there,

I'm trying to create a sparkline using VBA(just testing it out for fun)

Please Login or Register  to view this content.

I keep getting stuck at the word "Type" in the codeline. Error is on "Expression"

Has anybody had any experience using sparkline in VBA? The code comes from some website, but I have tried to modify it to suit my needs.

Any ideas?

Please Login or Register  to view this content.

should do it.

What is WSL? I assumed it was the codename of your worksheet.

Same problem - you have not assigned anything to ws. You need a statement like

Please Login or Register  to view this content.

for example.

"No luck" means what exactly? (I am on a phone so cannot review your file at present)

Please Login or Register  to view this content.

The target range made no sense given your data set.

Sparklines appear in one cell each. If you want something larger, use a chart.
I am not sure why you posted the same workbook again.

I was referring to your use of F2:H2 - which is why I changed it.

I'd greatly appreciate any help ....


this macro is meant to create a spark line for the selected range and put the results in the (row-2) range

[result on this row.......]
percent 11-Q1 11-Q2 11-Q3
a.Zero 1% 2% 3%
b.1-2 2% 3% 4%
c.3-5 1% 2% 3%
d.6-10 2% 3% 4%
e.>10 1% 1% 1%

I would select 1%...3% and the next 5 rows
I would want to put the sparklines in [result on this row.......]

thanks

Mark

Please Login or Register  to view this content.

MarkJPawlik,

Welcome to the forum. 2 pointers -

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Also you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.