Sounds good Paul!! Thanks!!
On Oct 3, 4:52 pm, Paul Schreiner schreiner_p...@att.net wrote:
Actually, I might be able to help here.
I'll have to wait until I get back to work on Monday though!
Paul
From: Chechu cecic...@hotmail.com
To: MS EXCEL AND VBA
Easier!! Given a sheet with the format I sent, I need to create an
output sheet opened by resource location.
On Oct 3, 3:33 pm, jamesdavey james_dav...@yahoo.co.uk wrote:
so you mean, for example, you want to add a new resource manually,
then press a button perhaps to update an output sheet?
Never mind, I received help elsewhere.
On Oct 2, 11:55 pm, vespid jrblack...@gmail.com wrote:
I'm making excel macros for the first time and getting things figured
out, but I have a few questions:
What code do I use to delete columns that have all empty cells EXCEPT
the top cell (row 1)
Dear Dilip,
I am not as good as you are. So, could you pls modify the Macro to suite
Indian Curreny i.e. Rupees (Rs) and Paisa.
Thanks
On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Zaheer,
Just answered this one a while ago. Check out and let me know if you
customer dzip New Customer
proctoandg 10024 procto
procto 10024 procto
procto 10024procto
bambo 13456 bambospecies
bambospecies 13456 bambospecies
barbs 200011
There are many lookups, what kind of information you need to warrant the
lookup function. Please tell us what is your problem precisely. dont make
us guess.
On Sat, Oct 3, 2009 at 12:20 PM, Equity Monk equitym...@gmail.com wrote:
Dear Friends,
I am attaching a portfolio. It is a mf
Hi Dilip,
Thanks a tonn for your kind help.
There is a typo in the second criteria which i send out earlier. Please read
it as under:
For other Customers, I need to follow up after 20*/25/30* calender
days (depending
upon the customer) from a given date (the given date can be today/yesterday
dear excel genuises,
may i request your help how to change the default message in excel 2003
status bar? and prevent the user from changing it.
thanks a lot. may god shower you with graces.
dellosa
--~--~-~--~~~---~--~~
Kindly unsubscribe me from the group.
Extreme Regards
Mahreen
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
Hi All
Please provide with a code which can put RGB cell values in colored cells.
Hugs
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
This is done !!
-Ayush Jain
On Oct 5, 9:54 am, Mahreen Ellahi mahreen.a...@googlemail.com wrote:
Kindly unsubscribe me from the group.
Extreme Regards
Mahreen
--~--~-~--~~~---~--~~
A Google search for:
excel vba read interior color rgb
returned Chip Pearson's site at Pearson Software Consulting, LLC:
http://www.cpearson.com/excel/colors.aspx
He's got examples and functions for returning the RGB values
for a cell.
hope this helps.
Paul
It looks like I spoke too soon.
I have code that will delete VB modules
and import vb modules,
but it cannot protect/unprotect the VBProject.
I took a look around the internet and from all
posts I've seen, it can't be done with VBA directly.
However, you CAN use SendKeys,
but that would mean
Thank You Paul
Regards
Umesh Dev
On Thu, Oct 1, 2009 at 7:40 PM, Paul Schreiner schreiner_p...@att.netwrote:
A Class is a way of defining a new object and attributes.
let's say you wanted to create an object called People.
Now, for each person in People you wanted to save the
Name
After making a chart in Excel 2007, you can right click on a Data
Series. then select Format Data point. The on the right, select
Border Styles. Within this, there's a way to set the width: say to
0.25 pt.
That's the GUI way of doing it, how can I change this width using VBA?
Have you tried recording a macro and then doing
these steps?
P
From: Sonny sonnyt...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Monday, October 5, 2009 8:55:18 AM
Subject: $$Excel-Macros$$ Excel 2007: How can I use VBA to set
On 10/5/09, Paul Schreiner schreiner_p...@att.net wrote:
Have you tried recording a macro and then doing
these steps?
P
Hi Sonny,
Go to tools macros recod new macro
you can right click on a Data
Series. then select Format Data point. The on the right, select
Border Styles. Within this,
17 matches
Mail list logo
