Hi,
any body help me , for prepare single pivot from more than one
worksheet.
regrds
deepak
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear All,
I want any VBA code or some tool to Unprotect Sheet in Excel 2007
I forgot the password..
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Please help me out.
Regards,
Subhash Yadav
On Wed, Jun 22, 2011 at 2:11 PM, Subhash Yadav scy2...@gmail.com wrote:
No, this is daily entry sheet for fuel issued to equipments. This will
continue for years.
Regards,
Subhash Yadav
On Wed, Jun 22, 2011 at 6:16 AM, ashish koul
Please help me out.
On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav scy2...@gmail.com wrote:
Dear Experts,
Please refer my attached file for which i want solution.
My queries are:
1. In the type column - Value is previous type+50. but if the values
are 300,550,800,1050,1300,1550 etc
Dear Venkat.,
Please find use below VBA code to Unprotect sheet in EXCEL 2007
Procedure : Press alt+F11
Insert-Module then Paste below code
Press-F5 to run
Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As
*For Internal Use of Employer (Please don't delete or modify while
replying to this email)* Monster Resume ID: 26603422 Personal Folder
ID: 9960481
*
*POSITION: MIS Executive (2 Positions)
Location: Noida
Objective- The executive assistant is responsible for providing MIS support
to
Dear Noorain,
Working Thank u So much...
*Best Regards,*
*Venkat*
On Tue, Jun 28, 2011 at 12:33 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Venkat.,
Please find use below VBA code to Unprotect sheet in EXCEL 2007
Procedure : Press alt+F11
Insert-Module then
try this.
use this UDF for the type columns. Pass the Previous Type value into
the function
Public Function CalculateType(Rng As Range)
If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value
= 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then
CalculateType = 50
ElseIf Rng.Value
Sorry...correction.
use this.
Public Function CalculateType(Rng As Range)
If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value
= 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then
CalculateType = 50
ElseIf Rng.Value = 750 Then
CalculateType = 250
ElseIf Rng.Value = 1000 Or
http://www.skills-assessment.net/home/frmindex.aspx
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Try the following macro :
Sub Test()
Dim rgRange As Range, Dict As Object, dblSum As Double
Dim strRecip As String
With Sheets(Sheet1)
Set Dict = CreateObject(Scripting.Dictionary)
Set rgRange = .Range(.[A2], .Cells(.Rows.Count, 1).End(xlUp))
Hi all,
I have written below syntax but got an error but I can't figure out
why
worksheets(sheet1).range(cells(x,1):cells(x,6).copy
worksheets(sheet2).range(cells(y,1),cells(y,6))
However, I can do it if I seperate it as follows:
worksheets(sheet1).range(cells(x,1):cells(x,6).copy
Hey Venkat,
It was very interesting. Can u pls. let me know whether it works in Office
2007 as i was not able to figure this out.
Thanks !!
On Tue, Jun 28, 2011 at 11:58 AM, Venkatesan c venkat1.sql@ gmail.comwrote:
Hi Deepak,
Find attached html file .for your queryYou prepare single
Hi,
worksheets(sheet1).range(cells(x,1):cells(x,6).copy
worksheets(sheet2).range(cells(y,1),cells(y,6))
is one same line so you have to add an underscore mark :
worksheets(sheet1).range(cells(x,1):cells(x,6).copy _
worksheets(sheet2).range(cells(y,1),cells(y,6))
Regards.
Daniel
-Message
The objects are locked. The object lock settings on the problem PC are
identical to those on the PCs not experiencing the problem.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
There is a sheet with name Sheet1 and it contains the following data:
A1 contains name, B1 Product, C1 Amount, D1 Email
A1B1 C1D1
Name Product Amount Email
Raj Shoes 1000 a...@a.com
Sun Socks 800b...@b.com
Raj Socks 700a...@a.com
Sun Ball500
*instead of : you should use , while using cells in range reference*
On Tue, Jun 28, 2011 at 6:12 PM, Ming mingtam...@gmail.com wrote:
Hi all,
I have written below syntax but got an error but I can't figure out
why
worksheets(sheet1).range(cells(x,1):cells(x,6).copy
I have a macro which works down through all the cells in a column,
parsing the contents of the cell for a particular text string. Here's
the general outline:
sCellValue = ActiveCell.Value
CharCount = sCellValue.Characters.Count
Found = 0
For i = 1 To CharCount
Mmm i have a doubt?is this trustable?if you have important company documents
that you have to put in excel format?
2011/6/16 saggi realsa...@gmail.com
Yeah this is very useful siten quick tooo
--
--
Some
Dear All,
Last night I made some changes in our Process MI Report through VBA code.
Today as per process requirement I need to change something but I forgot the
VBA password.
Is there any way to resolve the problem means to disable the password to
view the code.
*
Thanks Regards,
Gyana
*
On
Thanks Daniel,
Sorry I missed this in the post but actually I wrote this in one line
in the macro, but it doesn't work. The book tells me I shouldn't need
to activate the worksheet by indicating worksheets(XXX) in the code.
I believe I should have interpreted sth wrong, would you please point
Thanks Rakesh,
as I would like to get the copy range changed depending on the
variable I set in the macro. Actually, the code I wrote is something
like below
x = worksheetfunction.counta(worksheets(Sheet1).range(a:a))
worksheets(Sheet1).range(cells(3,1),cells(x,1)).copy
.
.
Sorry I am new
sCellValue = ActiveCell.Text
On Jun 29, 1:03 am, Jon Kanas ka...@qadas.com wrote:
I have a macro which works down through all the cells in a column,
parsing the contents of the cell for a particular text string. Here's
the general outline:
sCellValue = ActiveCell.Value
23 matches
Mail list logo
