Dear Group,
I have a Workbook where I want a macro such that if i click any unlocked
cell in any sheet or a particular sheet, all the contents of the said cell
should be copied and be ready to paste wherever i want.
Hope i will b able to get the macro as nobody on this group is left
unanswered.
Hi
thanks for revert but i dont want to use vlookup. I want macro code for
entering name n nos.
for example:
if i put Delhi in City field then name and phone nos of ADM and GM of Delhi
should automatically come in theri fields. Same as i put Mumbai .
Regards
Deepak Rawat
On Wed, May 20,
On Thu, May 21, 2009 at 2:41 AM, Dave wrote:
>
> Hi all, new to the group and fairly new to VBA programming. Here is
> my question:
>
> I'm writing a Macro to automate chart formatting tasks in Excel 2007.
> I noticed that the macro recorder does not record all of my steps and
> I can't figure o
Hi.
I have a list of URL links in a 2003 spreadsheet, tab name="Sheet 1",
first cell reference ="B2".
I have about 20 links and I am constantly adding to the list. Could
someone please help me with a VBA script that will automatically go
down the list and open up each url link? It would stop ru
Hi,
I required a urgent help, I had an excel file which i want to work in
shared, but in that file I am using macro with VB codes, I want help how to
run the macro while working in shared file using by more than 1 person at
the same time.
Please find the attached file for your reference.
Any hel
How can I change the code below so that VBA deletes any rows in the
current region where th value of the first cell is blank?
For Each rw In Worksheets(1).Cells(1, 1).CurrentRegion.Rows
this = rw.Cells(1, 1).Value
If this = last Then rw.Delete
last = this
Next
thanks for your feedbac
Hi all, new to the group and fairly new to VBA programming. Here is
my question:
I'm writing a Macro to automate chart formatting tasks in Excel 2007.
I noticed that the macro recorder does not record all of my steps and
I can't figure out which commands to use from the object browser so
hopeful
I have a problem with this code
shows me the following
"It has been defined by user-defined type"
I am new to this programming in VB Excel
GRACIAS
Function empleado(num As Integer) As String
Dim Cnn As ADODB.Connection
Dim Archivo As ADODB.Recordset
Dim Sql, Sqlc, busca As String
Set Cnn = N
Hi Deepak,
You can use the VLOOKUP formula.
Check the sheet2 in the attached file.
Revert for clarifications.
Regards
hpreddy
On Wed, May 20, 2009 at 10:40 AM, Deepak Rawat wrote:
> Hi all! i have attached a file, there is 5 fields in the file
> my requirement is, as i put city name in city
Akhilesh,
Thank you for your response. Though that line is helpful, it is not
what I need. Maybe this simple example will help clarify:
Sub test()
For i = 0 To 10
Range("A1").Select
ActiveCell.FormulaR1C1 = i
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Next
End Sub
The way that this is curr
thanks for link, but i want a way out without using macros
On May 20, 6:48 pm, Norman May wrote:
> Try the link below:
>
> http://www.mrexcel.com/archive/Formatting/12054.html
>
> Norman
>
> On Tue, May 19, 2009 at 1:50 PM, Balla wrote:
>
> > Hi,
>
> > M using excel 2003, and say i need to have
Still it asks for a password
On May 20, 11:05 am, H Upadhyay wrote:
> Hi Tariq
>
> Passwored.xla crack password, but there is some way that we know what is the
> password.
>
> Regards
> Harish Upadhyay
>
> On 5/18/09, tariq wrote:
>
>
>
> > hello mahesh,
>
> > this file password is : AABBBA
Hi Tariq
Passwored.xla crack password, but there is some way that we know what is the
password.
Regards
Harish Upadhyay
On 5/18/09, tariq wrote:
>
>
> hello mahesh,
>
> this file password is : AABBBAABBAAP
>
> AND ANY PASSWARD CRACKING SO MAIL ME ...
>
> my e_mail : tariq.78...@gmail.com & con
excellent thank you very much
On 19 mayo, 12:26, Fabio Lemos wrote:
> You have to enclose your parameter in ': see below;
> "SELECT user_code FROM ousr WHERE user_code= '" & busca & "'"
>
> 2009/5/19 Erikito1981
>
>
>
>
>
> > Hello everyone
>
> > I have a problem, I have this code which works
There are several ways of doing this, "using a macro in different sheets" -
u can assign macro to a shortcut, add as a button to the toolbar etc., Check
the below article, it will explain you how to assign macros to shortcut
keys, buttons and objects.
http://funwithexcel.blogspot.com/2009/05/macro-
Try the link below:
http://www.mrexcel.com/archive/Formatting/12054.html
Norman
On Tue, May 19, 2009 at 1:50 PM, Balla wrote:
>
> Hi,
>
> M using excel 2003, and say i need to have this below rule for a cell
> if value is "india", background color blue
> if value is "aus", background color yel
Dear OldRider,
You can record a blank macro and paste the code there.
Or you can go to VB editor and insert a module there. Then you can use the
code.
for Example:
Sub ColorRow()
ActiveCell.EntireRow.Interior.Color = RGB(255, 255, 160)
ActiveCell.EntireRow.Font.Bold = True
' Check for first exe
please attach the file.
2009/5/19 AYalcin
>
> Hello Everyone,
>
> I am very new in macro programming and would appreciate any help I can
> get.
>
> I have a workbook with two sheets. The first sheet has mm/
> labeled hyperlinks eg 03/2008, 04/2008.. 04/2009. When I
> press on the h
Hello Harmeet,
I think I have a solution for your problem.
see attached file.
Regards,
Sergio
2009/5/18 Harmeet Singh
>
>
> -- Forwarded message --
> From: Nihar Turakhia
> Date: Mon, May 18, 2009 at 12:47 AM
> Subject: VBA help needed
> To: harmeet.hew...@gmail.com
>
>
> H
Hi John,
Use ' before 0 os it will display number as '0985542.
Rgds,
MB
On Tue, May 19, 2009 at 7:21 PM, john wrote:
>
> I have a basi questions. When I try to enter a number with a leading
> zero, it ignores the zero and enters the rest. Where do I go to
> correct this so all numbers includin
Hi all!i have attached a file, there is 5 fields in the file
my requirement is, as i put city name in city field, then all the field
should fill accordingly
like as i put Mumbai, the names n Ph nos come accordingly ie. AMD_NAME=>ANIK
BHASIN AND ADM_PH => 9921356982 and the same for GM name as well.
Folks: G'day. I am an absolute novice at VBA and macros. I do get
around by adapting solutions provided by more knowledgeable and
learned people. So please be understanding.
This is the issue I am trying to resolve. I need to highlight the
current row I am using and I have the perfect code to use
Dear Friends,Can someone help me to run a macro to calculate the sum of a
cell across sheets...for Example
Sheet 1 B2, Sheet 2 B2 and Sheet 3 B3 have some numbers...now i want to run
a macro that will take the sum of cell B2 across the sheets, in Summary
sheet B2.
Thanks & Regards,
Vandana
--~--
Hi Dave and Team,
Thanks for the help provided. I have done this successfully with out any
issues.
once again thank you all for your valuable and swift response as well.
Regards,
Sharma
On Wed, May 13, 2009 at 10:50 PM, Fabio Lemos wrote:
> Hi,
> It's possible to use Validation, but it need t
HI all,
I have a sheet, from which i have to copy particualr data from the
sheet, then paste it in the fixed place in word and save the file as
*.pdf. there are hundreds of such cases to be dealt with. Is there any
way to have amacro in place to do it in a faster way.
In short :-
1) the macro sh
hello
i downloaded the (abletoextract professional) software for converting pdf to
word , for which excel group provided me a 16 digit pin also, but now after
30 days i want to use this software , its not working, if any can again
provide me that pin no.
Thans in advance
Puneet jain
Power Financ
You have to enclose your parameter in ': see below;
"SELECT user_code FROM ousr WHERE user_code= '" & busca & "'"
2009/5/19 Erikito1981
>
> Hello everyone
>
> I have a problem, I have this code which works fine me if I use is the
> field number but if the data is character sends me an error mess
I too have some files i have saved long back with passward and now
forgot the passward.
Please suggest the way to unlock the files on my own.
Thanks,
Prashant
On May 19, 1:26 am, prabhakar jain wrote:
> find unprtected file
>
>
>
>
>
> On Mon, May 18, 2009 at 4:50 PM, Dilip Pandey wrote:
> > H
Hi! I have to disable or hide minimize and restore buttons in excel
system menu. But this code works correctly in excel 2003 but not in
excel 2007. Excel 2007 hide only minimize button!
Dear John and all
Apart from the many solutions suggesting formatting as text or adding the '
sign, you could custom format the cell, thus retaining the number format and
having the leading zeroes at the same time.
For example if your numbers are of a fixed length of 6 digits so that "15"
is to b
Is there any code where by all the files saved in a particular folder gets
copied to a pre defined excel sheet .rather then writing the below code
75 times with different file names.
On Tue, May 19, 2009 at 2:17 PM, ritesh paul wrote:
> you have to write the below code 75 times in VBA
>
> W
Hi,
Try this code
dim dtDate as Date
dtDate = Thisworkbook.Names("IDO_Date"").RefersToRange.Value
for i = 2 to Sheets.count
sheets(i).select
if date(Range("B2").value)=dtdate then
Exit For
end if
Next
On May 19, 7:44 pm, Doug wrote:
> Hello,
> I have a work
Hi,
M using excel 2003, and say i need to have this below rule for a cell
if value is "india", background color blue
if value is "aus", background color yellow
if value is "sa", background color pink
if value is "eng", background color red
if value is "sl", background color navyblue
m using cond
Hello,
I need help in 2 macros. Any suggestions will be greatly appreciated.
thanks in advance.
1) Is it possible to run a macro automatically if certain cell value
changes?
e.g Cell A1 has a value which comes from a formula
and
1) Can I schedule a fixed time to run a macro.
--~--~-~-
34 matches
Mail list logo
