Hi,
What happended to the links in these summary mails with excellent q&a's.
Like "...more" that used to contain those links???
Regards, Jørgen Bugge, Norway
Sent from my iPad
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Hi everyone-
I'm trying to use VBA to print a specific "(1)ORDER FORM" worksheet
from workbooks that I'm receiving in Outlook. I've constructed the
following, but it keeps erring out when reaches the
Worksheet("(1)ORDER FORM").Printout line. I receive errors ranging
from error 9 to error 462 to er
Hi Everyone,
I was wondering if I could get help with a macro. I'm trying to write a
macro where the macro walks down a column of data based on where I
initially highlight the active cell. If the data in two consecutive cells
are different it adds 2 rows (or N rows). I've attached an example o
Hi Everyone,
I was wondering if I could get help with a macro. I'm trying to write a
macro (with no luck) that walks down a column based on the initial
placement of the active cell. Every time there are two cells with different
data it adds two (or N rows). It doesn't, however, view blank cel
Thanks, Vikas. Wow. This is great! I sincerely appreciate it.
On Thursday, March 13, 2014 10:18:44 PM UTC-7, Vikas Verma wrote:
>
> Hi E J try this...
>
>
> Sub testing()
>
> Dim rng As Range
> Dim rcount As Long
> Dim cel As Range
>
> rcount = Sheets(1).Cel
Thanks, Ravinder! I really appreciate it!
On Thursday, March 13, 2014 3:33:25 PM UTC-7, E J wrote:
>
> Hi Everyone,
>
> I was wondering if I could get help with a macro. I'm trying to write a
> macro (with no luck) that walks down a column based on the initial
> place
Hi,
Hope you are doing great!.
This is *venkat* from Fluxtek Solutions.
Below are my available consultants Hotlist. Kindly send the suitable
requirements and also add me in your mailing list. We do have additional
consultants available as well. Please send your requirements only to
v
Hi,
Hope you are doing great!.
This is *venkat* from Fluxtek Solutions.
Below are my available consultants Hotlist. Kindly send the suitable
requirements and also add me in your mailing list. We do have additional
consultants available as well. Please send your requirements only to
v
Hi Team,
We are looking for Sr. Recruiter and Business Development Manager (Sales
Professional) Requirements is for our Hyderabad Indian location. Please
take a look at below details JD and if you are interested send me current
salary package and expected salary package, availability to start
*Hi;
*
*Greetings from silicon staffing..
*
*Direct client rek Senior Java Spring Framework Architect
*
*Please send me your consultant profiles to *ku...@siliconstaff.com
*Monday is interview
Rate: open
Positions: 2* *
Location: Blythewood SCL
Start Date: Immediate
Dura
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
Hi experts, I need your help, I tried myself but unfortunatly its not
working.
I need UDF to sum range.
1) first my range will be B4:E4 and
I am going to drag udf into columns to next range will be C5:E5,
Means when I will drag my udf function it will increase in range by
1column and 1 row
:34:34 AM UTC+5:30, David Grugeon wrote:
> I think you need to fix the first part of youyr reference as in enclosed
> example.
>
> On 18 August 2012 13:43, Amol J > wrote:
>
>>
>> Hi NOORAIN,
>>
>> Thanks for your quick responce
>>
>> B
Hi Experts,
I have done this using Indirect(), Can you please help with UDF.
I waiting for your valuable reply
Regards,
Amol J
On Sunday, August 19, 2012 2:46:36 PM UTC+5:30, Amol J wrote:
> Hi All,
>
> Please help me with this problem. its related to range reference
following
Item STATE Sales
A MH 1
B MH 4
C MH 7
A GJ 2
B GJ 5
C GJ 8
A KA 3
B KA 6
C KA 9
Please help me on this problem.
Thanks,
Amol J
--
Join official facebook page
f VBA is not enough to solve this question.
Need your help.
Regards,
Amol j
On Monday, August 20, 2012 9:31:30 PM UTC+5:30, Don Guillett wrote:
>
> Your first sample showed a blank col B. Try this
> Sub rearranecolumnsSAS()
> Dim lr As Long
> Dim i As Long
> Dim
w a messge
(might be just a msgbox command)
have got many codes on the web but none has been working for me...
I use Microsoft Outlook. connected to a domain.
Can any one please help
Deepak J
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in
uit-sheet"
(example in this case the row number is 9)
Please let me know if you need any more clarifications from my side.
Please help me out at the earliest.
Thanks,
Blue J
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, acc
Hi Experts,
I need help
I have multiple shapes in sheet so i want color only one shapes in that
perticular sheet. So I created a function which Change the color of
provided set of shapes.
I want know how to pass array of shapes to function.
Please help me to solve this problem
Thanks
Amol
--
Thanks Divaker
Regards
Amol
On Tue, Jan 8, 2013 at 6:46 PM, Divaker Pandey wrote:
>
> PFA
>
>
> On Tue, Jan 8, 2013 at 1:40 PM, Amol J wrote:
>
>> Hi Experts,
>>
>> I need help
>>
>> I have multiple shapes in sheet so i want color only one sh
Thanks
On Wed, Jan 9, 2013 at 2:41 PM, Rajan_Verma wrote:
>
> Dim Shp As Shapes
> Set Shp = Sheet1.Shapes
>
> shp object will have all shapes reference with in sheet1, you can use
> shp(1) to color the first shape
>
> Rajan
>
>
> On Tuesday, 8 January
Hello Experts,
I need your help on how to change excel language. Please help me to clear
my below queris
1) I have written my vba in code in english and my excel file is going to
use in Germany on german systems with german language excel application. so
here is problem my some code is giving ga
hi shyam
can u try this one
=CONCATENATE(D12," ",D13," ",TEXT(D14,"dd-mmm-"))
On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
> out with this:
>
> Query:
>
> Column A : MS
> Column B : Exc
I am an estimator with a concrete company. I build new spreadsheets
for every bid. A lot of this is repetitious, same basic line item
again and again, just the square footage might change. For a better
idea of what it looks like:
Furnish and install ~7,010 s.f. of 4" concrete wearing slab for n
Hello
I have a xlsm (macro-enabled spreadsheet) file with IRM using free
Microsoft's authentication services (windows live based) to protect
the file from being redistributed without my knowledge and consent.
The IRM itself has been working flawlessly so far.
However, I have not managed to successf
Hello experts,
I have attached a sheet that I've been working on that is part of a
multi-step task that I have so far managed to cut over an hour a day from
the workload.
Overview:
I get roughly 50-80 emails daily with flight information related to my
company that previously was completed by some
I am a concrete estimator who is trying to create some cut and paste
Estimate line items I can just grab from one spread sheet and paste in
to my estimate.
I was refining one and tried to use the IF function to pick the number
of labor hours based on sq footage. More s.f. and we are more
producti
ing there.
>
> e.g.
> =IF(A3=3,"Equal",IF(A3<3,"Less",IF(A3>3,"Greater")))
>
> explaination
> if A3 = 3 value wil be "Equal"
> if A3<3 then value will be "Less"
> if A3<3 then value will be "Greater"
&
Tried to but was blocked from doing so. That is why I pasted what i
could.
On Dec 28, 9:48 am, Dilip Pandey wrote:
> Hi J D,
>
> It would be really appreciable if you can share a test file on this. Help
> us to help you :)
>
> Best Regards,
> DILIPandey
>
>
>
>
Nested IF functions?
> From: dilipan...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi J D,
> á
> It would be really appreciable if you can share a test file on this.á Help us
> to help you :)
> á
> Best Regards,
> DILIPandey
>
> On Tue, Dec 28, 2010 at 7:36
I am no whiz kid with Excel but use it all the time. I usually just
put a date in a cell drop to the next one and add 1. A1 would be the
date formated how I want, A2 would be =A1+1. I then copy and paste
that down the column or acroos a row. I have one spreadsheet that
covers the year. I just u
Hello,
I try to add a context menu to an excel sheet. The problem is that I
can not identify the current commandbar as it seems that this
commandbar is different wether you are in "normal view" or - and that
is the problem here - you are in "page Break Preview". If the sheet is
in the normal vie
32 matches
Mail list logo
