Mr Salva,
Just open visual basic editor (tools -> macros -> visual basic editor)
Double click on "This workbook" in project explorer.
copy & paste this code in code window.
Private Sub Workbook_Open()
Sheets("Sheet2").Select
Range("A494").Select
End Sub
Regards,
Kishan Reddy, K
On Sep
One can run a Billion Dollars company with Excel without any ERP support.
On Wed, Sep 1, 2010 at 9:41 PM, kamal shah wrote:
> Simply said than done.
>
> An IT Engineer starts career with Excel... reaches level of excellence in
> various technology and toolsbecomes Manager/ Director/ VP... en
Respected Excel Guru's
How to make the macro so that
When ever i start the file my cursor goes into that particular cell only.
For EX. Sheet 2 - A494 etc.
The purpose behing this is ex. i have set the target of achieving certain
amount -- so how much
still pending to achieve.
Thanks & have a
Posted it to the file list. It's called ISERROR Example.xls.
On Sep 1, 1:00 am, "C.G.Kumar" wrote:
> Kindly attach sample file.
>
> On Wed, Sep 1, 2010 at 12:12 AM, Kurt wrote:
> > Can't seem to get this working.
>
> > If A1 is a calculated error (e.g., #NULL) OR If A1 = "--- ", make
> > B1
Simply said than done.
An IT Engineer starts career with Excel... reaches level of excellence in
various technology and toolsbecomes Manager/ Director/ VP... ends up
working again on Excel !!!
So nothing changes.. First love remains First forever !!!
Ask this question to any Director/VP in wo
Hi all,
When I create a custom command bar in XL2003, I can attach it to a workbook
using Tools, Customize, Toolbars Tab, Attach. I can also remove custom command
bars in the same way. However, when I turn on the macro recorder to learn the
VBA syntax for doing this, nothing is recorded.
I ne
alternative to solving Aindril and if the code is not always located at the
end
try the UDF:
Function re_alpha_numeric(ByVal s As String, _
Optional bGlobal As Boolean) As String
Dim re As Object
Set re = CreateObject("vbscript.regexp")
re.Global = bGlobal
re.Pattern = "[a-zA-Z]*\d+[a-zA-Z]+|[
Try this formula.
Regards,
Solomon
On Wed, Sep 1, 2010 at 2:11 PM, Kal xcel wrote:
> Dear Experts,
>
> I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
> Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
> extract only product name (like: Skin Fr
Hi Kalyan,
You can use the following formula in the cell B2 and then copy it down
=LEFT(A2,LEN(A2)-(LEN(A2)-FIND("^^",SUBSTITUTE(A2," ","^^",LEN(A2)
-LEN(SUBSTITUTE(A2," ",""))
For more info on the above please check:
http://www.eggheadcafe.com/software/aspnet/28074391/need-to-find-first---f
Dear Experts,
I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
extract only product name (like: Skin Fruits Instant Fairness Fruit Bleach)
from that string.
File is attached.
Thanks in advance
Kal
Dear Friends,
>
> I am a beginner in Excel Macros...!
>
> I have worksheet with so many names in "column B" of the attached Excel.
> Actually I want to create separate sheets for all the names available in
> "Column B"
>
> *=>* Now I am able to check only the last sheet; and able to add new
> sheet
Hi,
Try this.
Open a new workbook.
If it's 2003 or earlier:
>From the Tools menu, select: Macro, Record Macro
Click OK in the window that appears.
Then selcet Cell A1 and type 123ABC
Hit enter.
With Cell A2 selected, colour the background Green.
>From the Tools menu, select: Macro, Stop r
Try this code:
ActiveSheet.ChartObjects("Chart 1").Activate 'For selecting the
chart
ActiveChart.Legend.Select 'For selecting legend
Selection.Interior.Color = vbRed ' for coloring its interior
Selection.Font.Color = vbBlue 'for coloring its font
ActiveSheet.Cha
Hello Folks,
I'm trying to build a dynamic excel scattor plot with the data points
color coded based on their value. This chart will report different
values for different scenarios.
I could change the color of data points but was unable to change the
color of data labels. Please let me know if I
14 matches
Mail list logo