Haha and the *master (vabz) *comes and the query resolved. I was looking
for this code. I have seen this code somewhere but it was slipped out of my
mind.
Gud one bro.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VB
I have a excel file which has 3 tabs by name A,B,C and then another
excel file with tab D - both the files are in server in same location.
All 4 tabs in both the files have one common column called as Chas
Can any one help me please to get a macro which can create a unique(no
duplicates) list of
hi
try this...
Sub RowsSelect3x()
Dim r As Range
Set r = Cells(1, 1)
For i = 1 To 1000 Step 3
Set r = Union(r, Cells(i, 1))
Next
r.EntireRow.Select
End Sub
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 25, 2014 at 12:50 PM, Mandeep Baluja
wro
I just want to know whether it's is possible with the help of code or not.
I can achieve the same with the help of helper column using a mod function.
On Monday, November 24, 2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote:
>
> Dear All,
>
> I hope you have a correct idea for my question I am as
bosss, you're not getting me i know that code is fine what I want is to run
a loop for my query select every alternate rows. why should i write
1:1,3:3,5:5.10001:10001.
Basically i can certainly understand to do an ope
can any one pls?
On Monday, November 24, 2014 7:44:09 PM UTC+5:30, Laxmanan M wrote:
>
> Hi All,
>
> I have done with the macro code for the Vendor file validation.But i need
> to make some amendments in the created code.The amendments requirement has
> been placed in the attached word document.
Hello All,
Thanks all for your help. :)
On Mon, Nov 24, 2014 at 10:51 PM, Paul Schreiner
wrote:
> Do you understand what it MEANS to calculate a percent?
>
> 10% means 10 out of 100 or 10/100 .10
> 50% is 50 out of 100 or 50/100 or .50
>
> so, you CANNOT display 1 as 1% because 1% isn't 1, it's
Sub Exercise()
Range("1:1,3:3, 5:5, 7:7").Select
End Sub
See this how this rows are selected I want automation for this with the
help of loop .
On Tuesday, November 25, 2014 11:21:46 AM UTC+5:30, Mandeep Baluja wrote:
>
> Sorry not working try this this also selecting the
Sorry not working try this this also selecting the whole range.
On Monday, November 24, 2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote:
>
> Dear All,
>
> I hope you have a correct idea for my question I am asking to select rows
> in data with the help of loop. Please note that what i want is to
Dear Mandeep,
Pls try this...
Sub SelRows()
Dim R
Rows(1).EntireRow.Select
For R = 2 To 100 Step 3
Range(Selection, Selection.Rows(R)).Select
Next R
End Sub
Thanks & Regards,
Ganesh N
On Tue, Nov 25, 2014 at 9:41 AM, Mandeep Baluja
wrote:
> Sorry to say I was not looking f
Mr Paul,
Thank for your consider.Let me explain more :
There are lots of parts within machine so i would like to list detail of
their working stop time ,however when calculating downtime i only calculate
actual stop time and eliminate overlap time.
Son
2014-11-24 20:47 GMT+07:00 Paul Schreiner :
Sorry to say I was not looking for this , Try to run this code it will
select 1 to 10 rows. Lets change the code little bit run it and found it's
still selecting all what i want is select rows after every three and keep
the previous rows selected too. Every one can do a operation with alternate
Do you understand what it MEANS to calculate a percent?
10% means 10 out of 100 or 10/100 .10
50% is 50 out of 100 or 50/100 or .50
so, you CANNOT display 1 as 1% because 1% isn't 1, it's .01
the only way you can do this is to create another column and have it calculate
a percentage:
=A2/100
(
What version are you USING?
(are you using 2007 and opening a 2003 file?)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you
I suspect the issue you're concerned about is when you're using vlookup on an
entire column.
2003 is limited to 65,536 rows.
2007 and above have 1,048,576 rows.
To get past this, you need to be sure to have less than 64,000 rows.
That is, you CANNOT use a range like: B:E
but you must limit it t
Dear Excel guru's,
I have 4 Data in 2003 excel format. I want to vlookup in 10 data,
its 2007 excel format... Am trying to vlookup in 2003 to 2007 excel format
the below attached error is came. Please solve the error...
[image: Inline image 1]
Thanks & Regards
Sriram G
On Mon, Nov 24, 2
There is no difference between Vlookup in Excel 2003 and Excel 2007 and
above. Please elaborate what is the actual issue.
On Mon, Nov 24, 2014 at 9:55 PM, sriram ji wrote:
> Dear Excel Guru's,
>
> Is there any possible to vlookup in 2003 excel to 2007 excel or above.. If
> possible please provid
Dear Excel Guru's,
Is there any possible to vlookup in 2003 excel to 2007 excel or above.. If
possible please provide the excel vlookup formula.
Thanks in advance.
Sriram G(chennai)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join officia
Chandru find the attachemnt ihad get given above it will take the format as
value. Ashish i know that its a concatenate function but as you are not aware
about the fact whenever a concatenate function is used with text that value
turned into a text .
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Then just change the cell format to percent.
The VALUE remains the same.
Cell formatting simply changes the way it is DISPLAYED.
Keep in mind that a value of 1 is 100%
90% is .9
So, if your VALUE is something like 65,
that's not a percent.
(unless you were expecting 6500%)
Paul
-
Hello All,
I want it as value not text and am not adding with any value just I need to
display it as value with percentage.
Thanks in advance.
Regards,
Chandru
On Mon, Nov 24, 2014 at 6:51 PM, Paul Schreiner
wrote:
> As a percentage of WHAT?
>
> is your value already a calculation?
>
> That
Evidently, you're not the ONLY one wondering about Debug.Assert!
I just responded to another query about the same thing!
I included it here too, just for future reference.
As for:
If ((ActiveSheet.Range("A1").Value & "X" = "X") _
And (ActiveSheet.Range("B1").Value & "X" <> "X")) then
I suppose
OOps... I meant to remove that.
But I'll explain.
When debugging a large/complex macro, it's often helpful to use "breakpoints".
(do you use breakpoints?)
Breakpoints:
you select a line and hit the "hand" icon or simply click in the left-hand
border in the editor.
I've often had SEVERAL brea
You misspelled "Change" in Worksheet_Change
??
If you use the "Wizard" in VBE it would avoid this:
(top-left pulldown to select "Worksheet", top-right pulldown to select "Change")
also, might I suggest using something like:
Private Sub Worksheet_change(ByVal Target As Excel.Range)
Di
Thanks Mandeep,
Thank you so much..Lax
On Monday, November 24, 2014 3:18:45 PM UTC+5:30, Mandeep Baluja wrote:
>
> Set the columns for emails. it will take email one by one and send the
> mail from outlook automatically without showing any notification you can
> also use msgbox function to chec
What do these times represent?
Why would the equipment be recorded as down 9:00-12:00 AND 10:00-11:30?
Is there a minimum recording increment?
as in: 5 minute minimum or is it (1) minute increments?
I'm considering setting up an array of increments for 24 hours and "flagging"
the increment to
You could try something like;
Sub CheckColumns()
Dim inx As Integer
Dim MyArray
Dim HdrFlag As Boolean
Dim LoopCnt As Integer
MyArray = Array("employee", "department", "salary", "year", "position")
LoopCnt = 0
HdrFlag = True
While HdrFlag = True And LoopCnt < 10
You mean like:
Sub SelRows()
Dim R
For R = 1 To 10
Range(Cells(1, "A"), Cells(R, "A")).EntireRow.Select
Next R
End Sub
??
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At
As a percentage of WHAT?
is your value already a calculation?
That is:
if your "value" is a number in a column of numbers
and you want to show what percent it is of the total,
you' add a formula to an adjacent cell like:
=A1/SUM(A:A)
then, simply format the cell as "%".
if the cell alrea
Hi Mandeep,
If your Data in Cell A1 then put the formula in B1. This is concatenate
function. Try it...!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/disc
Nopz but I just want to learn new things if it works bro.
On Monday, November 24, 2014 6:06:55 PM UTC+5:30, Ashish Kumar wrote:
>
> Dear Mandeep,
>
> Are you trying this formula.
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N
Dear Mandeep,
Are you trying this formula.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles.
Hey Ashish, Dont you think it will be converted to text if you use that
formula.
On Monday, November 24, 2014 5:50:29 PM UTC+5:30, Ashish Kumar wrote:
>
> Hi Chandra Shekar,
>
> Use this formula :
>
> =A1& "%"
>
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Dear Chandru,
Kindly find the attached file.
Regards,
Mandeep Baluja
On Monday, November 24, 2014 5:41:42 PM UTC+5:30, Chandru wrote:
>
> Hello ,
>
> I need to display value as percentage could you please help me on attached
> file.
>
> Thank you,
>
> Chandru
>
--
Are you =EXP(E:RT)
Hi Chandra Shekar,
Use this formula :
=A1& "%"
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread ti
Hello ,
I need to display value as percentage could you please help me on attached
file.
Thank you,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FO
Dear All,
I hope you have a correct idea for my question I am asking to select rows
in data with the help of loop. Please note that what i want is to run a
loop select a row move next and *keep the previous row selected too*. I
need a efficient code for this.
Regards,
Mandeep Baluja.
--
Set the columns for emails. it will take email one by one and send the mail
from outlook automatically without showing any notification you can also
use msgbox function to check the list of of users one by one. here the
email column is For Each cell In Range("AJ2:AJ300")
Regards,
Mandeep Baluja
38 matches
Mail list logo
