with in the past, feel free to hang onto my email
address and contact me directly.
I would enjoy keeping in touch.
I'm sure you'll find me on other VBA help sites!
Paul Schreiner
--
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
At the bottom of each message, there is the address to use to unsubscribe.
I'm nearly to the point of doing so myself...Really disappointed that the
owner/moderator doesn't enforce the rules for the group (re: #5:)
Paul-
“Do all the good you can,
By all
, Jul 30, 2018 at 6:20 PM, Paul Schreiner wrote:
I've done something like this before using a couple of different methods.
It's really going to depend on what you're trying to "block".
For instance, if you want to keep someone from deleting any of the rows 1-8,
thenyou can use a Selec
I know!Right?I had them all blocked and something happened and now they all
started getting through.I'm very close to unsubscribing from the list because
of all of the job postings.
One other sight that I used to participate in simply closed down completely
because of the spam postings.
I've done something like this before using a couple of different methods.
It's really going to depend on what you're trying to "block".
For instance, if you want to keep someone from deleting any of the rows 1-8,
thenyou can use a SelectionChange event to test for selected rows in the 1-8
range
You can use:
=IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>0),"Yes","No")
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
the formula seems to work as it is designed.So what kind of help do you need?
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
What does your macro look like?
I recorded a macro, then "cleaned it up".the result being:
Sub PageFormat
ActiveSheet.PageSetup.LeftFooter = ""
ActiveSheet.PageSetup.RightFooter = "" End Sub
it seems to work great in Excel 2010
Paul-
“Do all the good
Yes... that's what this group is for!
If you tell us what the issue is what you've done so far, there's lots of us
available to help! 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
First of all, just as suggestion, take a look at the Forum Rules.the first is
more of a recommendation than a rule, since violating it doesn't get you banned
from the group, but it COULD make it take longer to get an response:
1) Use concise, accurate thread titles. Poor thread titles, like
Pravin Gunjal
On Tue, Dec 5, 2017 at 5:51 PM, Paul Schreiner <schreiner_p...@att.net> wrote:
Sure, the "trick" is that you have to start at the last row and work your way
"up".
because otherwise, when you delete a row, the "next" row moves up into the
delet
=234, B2=234, B3=234, B4=234, B5=234, B6=234, B6=234, B7=234, B8=234,
B9=234, B10=234, B11=323, B12=323
Thanks
On 5 December 2017 at 15:26, Paul Schreiner <schreiner_p...@att.net> wrote:
Please elaborate.
I understand that you have random numbers in column A.how many? do
Please elaborate.
I understand that you have random numbers in column A.how many? do they change
when the workbook calculates? or are they "fixed"?
What do you mean: " I want column B to pick from A"Do you want to randomly
select a random number from column A?
then: "fill one number 10
Sure, the "trick" is that you have to start at the last row and work your way
"up".
because otherwise, when you delete a row, the "next" row moves up into the
deleted position, then the loop would skip over that record.
By starting at the bottom, the row that moves up has already been
I've never heard of it, but:A) This is a site for Excel macros, not "Power Bi"
B) a Google search took me to the Microsoft site:
https://powerbi.microsoft.com/ that has guided learning.
Google also indicated YouTube channels and more("Power Bi tutorial" has over
1,000,000 hits)
Are you trying to look up the date from J1?
If so, wouldn't it be:=VLOOKUP($J$1,INDIRECT("'"&"'!"&"$A$3:$F$3"),5,0)
and, I'd suggest changing $F$3 to something like $F$1000
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In your macro:Sub sbCompareColumns_2()
iCntr = 1
Do While Cells(iCntr, 1) <> ""
If UCase(Cells(iCntr, 1)) = UCase(Cells(iCntr, 2)) Then
Cells(iCntr, 3) = "Matched"
Else
Cells(iCntr, 3) = "Not Matched"
End If
iCntr = iCntr + 1
Loop
7 9:27 AM, rathi rupenzala
<rathi8rupenz...@gmail.com> wrote:
How do I draft it in code with loop ... please help !!!
On Tue, Oct 10, 2017 at 6:45 PM, Paul Schreiner <schreiner_p...@att.net> wrote:
You could use a simple formula in column B, starting in B2
with:=IF(A2<>
You could use a simple formula in column B, starting in B2
with:=IF(A2<>"",A2,B1+1)
and copied down.
Excel automatically calculates the next date and considers leap years when
doing so. Paul-
“Do all the good you can,
By all the means you can,
In all the
sure.fairly easily done.Please provide sample files.
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 can.” - John Wesley
This is pretty "convoluted" logic.I tried several approaches that soon became
extremely complex (as if this isn't?)
The approach is this:Establish a starting date of 01-Jan of LAST yearand an
Ending Date of -1-Jan of NEXT year.(I could've hard-coded these dates, but then
you'd have to edit the
I have no idea what you're trying to do.You have one sheet called "ven" which
has 998 rows dating from April 1, 2017 to December 24, 2019then you have a
sheet called "ledg" which has 2009 rows from to April 1, 2016 April 10,
2016.None of the dates overlap, so trying to guess what you're trying
SVG files are in XML format.In the past, I've used Excel VBA to open XML files
as a "text stream" and parsed out the data to extract data.
If you can send me a sample file and tell me what you're looking for "model
number" and what values you expect to extract, I can see what I can do to
I think you'll need to be more specific on how you want the "weeks"
calculated.For instance, in August (2017) August 1 is on a Tuesday.
so, the weeks are handled:
but, July 1 is on a Saturday,so, does Week 1 only have a single day?
Or is July 1 counted as part of week 5 of June.If so, what is
I took a quick look, but since I don't have any .CDS files, it didn't work
properly.
But a couple of observations:#1) I'd add Option Explicit to the start of the
module, to ensure all variables are declared.#2) It's curious that your
editors aren't showing a compile error on "Dim Dirpath as
use:=INDIRECT(E3) 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 can.” - John Wesley
I'm not sure I COMPLETELY understand, but at least I can give it a start.
first: your description keeps saying "BD = ..."But your workbook has a column
heading "DB", so I'm assuming one or the other is transposed.
also, .06% is .0006 do you really mean "B Value" * .06 (formula: =B2 *
.06)or"B
Sir: I realize you are new...But if you read the Forum RULES, #4 specifically
states:4) Jobs posting is not allowed.
I have nearly 100 users that I've had to block from my email because they
joined for the sole purpose of head-hunting.That's not what this site is about
and not why I joined the
ontain confidential information or information protected under
solicitor-client privilege. Please advise if you wish us to use a mode of
communication other than regular, unsecured e-mail in our communications with
you
On 20 June 2017 at 11:15, Paul Schreiner <schreiner_p...@att.net> wrote
r, unsecured e-mail in our communications with
you
On 19 June 2017 at 15:41, Paul Schreiner <schreiner_p...@att.net> wrote:
That didn't answer my questions. Paul-- ---
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places y
egular, unsecured e-mail in our communications with
you
On 19 June 2017 at 10:53, Paul Schreiner <schreiner_p...@att.net> wrote:
There's not enough information for me to guess how you want the summary
populated.
How "dynamic" is your data?Is the number of Products variable or fixed?is th
There's not enough information for me to guess how you want the summary
populated.
How "dynamic" is your data?Is the number of Products variable or fixed?is the
number of Customers variable or fixed?
Paul-
“Do all the good you can,
By all the means you
I have previously dealt with similar situations.
In one case, I have an application that has over 164,000 rows and 74
columns.Frequently, queries and reports retrieve records based on multiple
columns.
VLOOKUP became much too time consuming, but due to the volatile nature of the
data,
range: "...in a column and name the range "Input""?
Op dinsdag 6 juni 2017 18:25:43 UTC+2 schreef Paul Schreiner:
You're saying that F77 is a calculation that uses the value of F5.You want to
change F5 from 1 to 100 and do WHAT with the resulting value in F77?
Are you saying tha
You're saying that F77 is a calculation that uses the value of F5.You want to
change F5 from 1 to 100 and do WHAT with the resulting value in F77?
Are you saying that you want to simply put 1-100 in one column and then show in
an adjacent column the result when this number is put into F5?
Is the
>From the looks of your macro, I think we need to help understand the
>SelectionChange event.
#1: the "Selection" is passed to the event sub through the "Target"
variable.So.. Target IS Selection!
It is an array, but a single cell gets passed as an array of (1).
What I usually do is cycle
There are LOTS of reasons why macros can be slow.And.. "slow" is relative.
I have a workbook with over 130,000 rows and 72 columns.
I can report summaries for these rows in SECONDS.
my macro USED to take several minutes, but I simplified the code and found that
it was looping through the lines
Let's say that you have 100 rows of data. "bottom" ends up being 100.so your
Rows statement results in:Rows(R:100).insert shift:=xldown
I think it needs to beRows(100:100).insert shift:=xldown
so you'd use:Rows(r & ":" & r).Insert Shift:=xlDown
Paul-
“Do
appreciate your quick response, However when i say raw data it means just
simple table in Excel which i have shown in attached excel sheet only in column
L and M.
So you can consider it as requirement or data rearrangement from table 1
(Column A to G) to table 2 (Column L to M).
I hope now
There is no standard format for "Raw Data".It depends on the original
Application used to CREATE the source of data.Some systems output ASCII (text)
files Some are tab delimited.Others are comma delimited (csv).
The mechanism you used to read in the "raw data" used known characteristics of
the
7 16:11, "'Martin George' via MS EXCEL AND VBA MACROS"
<excel-macros@googlegroups.com> wrote:
------ --
On Thu, 5/25/17, Paul Schreiner <schreiner_p...@att.net> wrote:
Subject: Re: $$Excel-Macros$$ Links
To: "excel-macros@googlegr
Macro got run and gave finished message.
Where can I find the desired output?
Regards, Kaushik
On May 25, 2017 19:06, "Paul Schreiner" <schreiner_p...@att.net> wrote:
OK.Spent WAY longer on this than I should have.
I should've had you create a "dummy" set of workbooks
there is a worksheet named A in workbook. It is linked to
external workbook named say X, Y and it is also linked to worksheets in
workbook say name B, C, D, E in different cells.
What I want is in new workbook it should displayWorksheet A - Linked from
external workbook X, Y and intern
It sounds like you're not wanting to REMOVE the links,but basically generate a
list of worksheets and the name of the external workbooks linked to those
sheets.
That doesn't sound difficult.
But the error you're suggesting doesn't make sense because you're not "pasting"
anything (with the macro
e is not working.
Can you please provide full code starting with Sub...till End sub
Regards,kaushik Savla
On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner <schreiner_p...@att.net> wrote:
If you also want to get rid of the "internal" links and formulas, you can make
use of the fact t
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 can.” - John Wesley
-
On Tuesday, May 23, 2017 2:56 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com>
wrote:
This
That's very CPU intensive because it copies all cells to the clipboardand
pastes them from clipboard.which can be a HUGE number of cells for each sheet.
If you simply want to break the external links, you can use something like:
alinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not
So, you're wanting to find out what other documents are being linked?
something like this will count the number of referenced links:
cnt = 0
alinks = ActiveWorkbook.LinkSources(xlExcelLinks)
' MsgBox alinks.Count
If Not IsEmpty(alinks) Thenmsgbox "Links: " & UBound(alinks)
There are several approaches.Using Excel functions, I would concatenate the
values;=A2&"_" would result in:SNUser1001 25 1001_251002 25
1002_251003 26 1003_261001 25 1001_251004 26 1004_26
Then you can use your functions to count unique values of column C.
You can do something
I've Googled extensively and tested multiple options for more than 30 hours
over the last couple of weeks.
The results of my searches all LOOK reasonable, but all have failed to
function properly.
I have some SUSPICIONS as to why it's not working, but that doesn't lead me
to solutions.
Here's
how are you defining the corresponding cell?Is it the same cell in a different
sheet?or is it the same "offset"That is:Range 1 is 3 rows x 3 columns beginning
in cell A1 andRange 2 is 3 rows x 3 columns beginning in cell E1
there's lots of ways to do it.In some cases, you can hard-code the
The steps would be:1) Select all cells Right-Click and select "Format Cells"
go to "Protection" tab and make sure "Locked" is selected. Select "OK"2)
Select all cells you want to be able to select/change Right-click and select
"Format Cells" on "Protection" tab, DE-SELECT the "Locked"
Here's the approach I took:I defined a "public" Dictionary object called
Dict_Category.I created a function to load the Dict_Category with the category
listing from the "DATA" sheet.
Being a "public" variable, the values are retained while the workbook is open.
I created two worksheet
I'm a HUGE fan of the Dictionary Object.
It has multiple uses.In it's basic form, it defines a unique "index" for a
two-dimensional array.
Let's say you have a large worksheet and you want to get a list of unique
values from column "A" a count of each.
You can cycle through the rows and check to
What I would do is first load your "Roll No." values into a Dictionary
object.Then, loop through your "S.No." values and look to see if they are in
the Dictionary.Report the missing values.Like:
Sub Find_Missing()
Dim Dict_SN, SN
Dim nRows, nRow, drow
Set Dict_SN =
; wrote:
Dear Paul,
Thank you so much for your support but I don't have need formula calculation
start from today. It should be start from my provided date...pls recheck that
time my file i am sure you will be got my query.
On Mar 4, 2017 1:58 AM, "Paul Schreiner" <schreiner_p...@
had to be
computed, locked cells had to be overwritten and that was not permitted.
If there is a possibility of talking to explain things that I want to
accomplish with the excel, do let me know.
Otherwise, I will have to explain here and get it done.
Thanks,
Maatangi
On Friday, 3 March 2017 18:
First of all, your IF() statement:A nested if statement will evaluate each
section until it finds a true() option.So, in the first
case:IF(TODAY()<=42750evaluates false, that means today is > 42750So the second
part: IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test
it!Your
tect the sheet,
then users are unable to edit / input their values where necessary. Is there a
VBA workaround for this? Most of the date fields have to be locked as well and
should not be allowed to be changed by users.
On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul Schreiner wrote:
I deleted a row a
I deleted a row and received the "Type Mismatch" error.If you select "Debug",
you'll see that the offending line of code is: If Target.Value =
"OrderStatus" ThenPutting a "watch" on the Target variable, you'll see that it
isn't a single cell, but an array of cells!
When you change multiple
Your question is extremely vague.
The simple answer is: yes.
Simply use find/replace (ctrl-h)enter JAY BHAVANI COAL FILEDS PVT. LTD. in the
"find what:" fieldenter Jay Bhawani Coal Fields Pvt Ltd in the "Replace with:"
fieldand click the "Replace All" button.
Is THAT what you're looking to
Its simple enough to determine the last 4 characters using the right()
function.But because the length varies (from 7 to 11), you need to be a bit
more "creative" with the left() function.
try inserting a column with:=LEFT(F3,LEN(F3)-4)&"-"(F3,4)
copy to all rows, then copy/paste Values to
will miss having a breakthrough. It’s okay to do what you did yesterday, but it
will never be amazing again.". - Rod Favarod, CEO of Spredfast
On Mon, Feb 20, 2017 at 7:55 AM, Paul Schreiner <schreiner_p...@att.net> wrote:
How are your survey results stored?Are they separate files?or hav
How are your survey results stored?Are they separate files?or have you already
combined them into one workbook?
What *I* would do would define an array:Results(QuestionNo, QuestionVal)
Dim Results(1 to 4,1 to 5)
Then, go through your surveys and increment the array value for each
questionThat
The answer is:Yes.
The long version of the answer involves describing the "scope" of variables.
First of all,in each VBA module, I recommend using
Option Explicit
as the first line of the module.This forces the compiler to check that all
variables are EXPLICITLY declared.without it, the first
The Match() function will return the relative column for the date matching the
header.So: Your array of data is in E1:AI1 and if you're looking for the date
in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for
when you copy the formulas)
In this case, the function
The format .csv is a comma separated field format. (Comma Separated Values)
You should be able to use File->Save As->and choose this type.
I'm not sure what you're expecting with the "space between all columns and
values".
If you are expecting a comma AND a space between each column,then you're
I took a quick look myself.There doesn't seem to be a "standard" data type
called "Table".
Where you've used it before, do you have other macros (or class modules) that
define this data type?
In the other application (that works) try right-clicking on the word "Table"
in: Dim myTable As Table
You can create a Worksheet_Change event.check to see if the cell changed
(Target) is the cell with your pull-down selection, then process accordingly:
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Address = "$A$4") Then
Debug.Assert False
End If
End Sub
Please remember to follow forum rule #1:1) Use concise, accurate thread titles.
Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or may not be answered.
It helps to attract a person best able to assist in the
Are you wanting the end result such that cell A19 contains "Bill" (the value of
A2)A20 = JoeA21 = DaveA22 = Fredand so on, then repeating this series for 15
sets?
For THAT, you could use something like:Option ExplicitSub Dup_Sets()
Dim nRow, nRows, dRow, SetCnt, SetNo
SetCnt = 15
The "escape" character in Excel filters is a tilde (~)
so, in your filter, you could look for records that begin with ~*~*
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
What exactly are you trying to do?I see in your attachment, that you have a
list of employees with Department, Hiring Year, Region, Gender and "Amount"
Then, it seems you've begun a list with only the Hiring year, Gender,
Department and Region.
so, are you simply taking the information from the
Hi Paul
I tried to modify the code according to attached data set, but its not going
through. Would you, please look into this.
Both details are extracted from ERP, So need to convert them as number before
running the macro.
On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner <schreiner_p..
First of all, take a look at the Forum "rules".some of them are just simple
good ideas, like: 1) Use concise, accurate thread titles. Poor thread titles,
like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
Advice will not get quick attention or may not be answered.
The
-- --
On Tue, 1/10/17, Paul Schreiner <schreiner_p...@att.net>
wrote:
Subject: Re: $$Excel-Macros$$
Index+Match+Indirect+Address
formula
To: "excel-macros@googlegroups.com "
<excel-macros@googlegroups.com &
nypt...@gmail.com > wrote:
Paul, Thanks for your reply. Can we extract the details of first occurrence.
there might be some issues with the sample data, always the data will be unique
and clean.
On Jan 9, 2017 8:36 PM, "Paul Schreiner" <schreiner_p...@att.net> wrote:
I'm not
. Can we extract the details of first occurrence.
there might be some issues with the sample data, always the data will be unique
and clean.
On Jan 9, 2017 8:36 PM, "Paul Schreiner" <schreiner_p...@att.net> wrote:
I'm not sure what RESULT you're expecting.
For instance, Order ID #
I'm not sure what RESULT you're expecting.
For instance, Order ID #CA-2014-AB10015140-41954 has two entries in the
"Dump.xlsx" file.Row 40098 is identical to row 40099 except for the Product
related data (ID, Category, Sub-Cat, Name, Sales, Profit, Shipping)
So, what do you wish to record in the
Take a look at the macros in the attached file.Note: macros cannot be stored in
.xlsx files. They must be in type .xlsm or .xlsb (which I prefer)
Secondly, the use of terminology in the description of your requirement is
important.In your requirement: "I want to transfer all the 31 workbooks to
Does the current path have more than one zip file?more than one csv file?
How do you determine which zip file (and csv file) you will process?(is it the
latest file?)
You can use the FileSystem object Set fso =
CreateObject("Scripting.FileSystemObject")
to cycle through the folder, looking
This can be done fairly easily with VBA:Sub CopyCells()
Dim Rng As Range, nRow
'---
Sheets("Sheet1").Cells.ClearContents
nRow = 0
'---
For Each Rng In Sheets(1).UsedRange
How do you envision this working?Say:You have folders:
January 2016February 2016March 2016April 2016May 2016June 2016
in each folder you have 30 files (presumably Excel files)In your sample
file, you said you "want to move all thirty sheets".Does that mean that there
is only one sheet in
Dear Paul Thanks for replyPlease find detila you asked forThere will be
seperate summary sheet which contain folowingPlease find attached sheetThanks
once again for great Help
RegardsShrinivas
On Wed, Jan 4, 2017 at 7:52 PM, Paul Schreiner <schreiner_p...@att.net> wrote:
My Google calendar displays multiple calendars.
I'm trying to write a VBA macro to read from the Google calendars and
create a "composite" calendar in Excel that highlights
conflicting/overlapping schedules, and more.
The first step is to read from the Google calendar and write the event
This can be easily done.I recently created a "Combined Summary" report that
opened over 500 files in subfolders and copied 160 columns of data from a
variable number of rows on the "Summary" sheet of each workbook to the
"combined" workbook.Resulting in over 2700 rows of data.Since the files
24 GMT+05:30 Vijayendra Rao <vijayendrar...@gmail.com>:
Thanks Paul for your help, it is working fine. You saved my lot of time.
Thank you again.
Regards,Vijayendra
2016-12-13 17:41 GMT+05:30 Paul Schreiner <schreiner_p...@att.net>:
I'd suggest changing the HideAllSheets macro to first di
Your buttons call two separate macros.Print_OptionandSUPPRESS_ROWS
to combine the two, simply have the Print_Option macro "call" the SUPPRESS_ROWS
macro, like:
Sub Print_option()
SUPRESS_ROWS
Application.Dialogs(xlDialogPrint).Show
End Sub
Paul-
“Do
Could I get a copy of the sheet?What do you base "current" year on, the year of
"today's" date?(rather than a fiscal year or other criteria)
There are several options.But I'd rather not try to recreate your data, only to
find out my creation doesn't match yours!
illed my most of the requirement. One last
favor, Now while opening last saved sheet only visible and
guidelines sheet is hide , is it possible to view only
first
sheet (sheet name read) of the file.
Regards,Vijayendra
2016-12-12 18:52
GMT+05:30 Paul Schreiner <schreiner_p...@att.net
ch
automatically hide those sheets when close the file.
Attached is the my workbook.
Regards,Vijayendra
2016-12-12 17:46
GMT+05:30 Paul Schreiner <schreiner_p...@att.net>:
Just
as you created a macro to "unhide" the sheets, you
need to create a macro to hide them.
Additional
Just as you created a macro to "unhide" the sheets, you need to create a macro
to hide them.
Additionally, you can create a BeforeSave event to check to see if the sheets
are displayed.Then execute your "Sheets_Hide" macro to hide the sheets before
saving (that way the sheets are always hidden
There are services you can obtain (try Googling "excel password recovery")but
the rules of this forum include:
3) Don't post questions regarding breaking or bypassing any security
measure.
(I think the list owners don't want the liability associated with assisting
someone to bypass the
What do you mean by "not working properly"?
I opened your file and compared the values to the expected values and it seems
to be working as expected. Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you
You're not defining a delimiter.Are you using a comma (,) as the delimiter?
then you need Comma:=true, 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
It looks like it's a problem with your FieldInfo:= value.
You have:FieldInfo:=Array(1, 1)
when I recorded a macro, it used:
FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)),
when I modified it to fit in your macro, it worked.
although, I suspect you should change your
OK, I'd need a bit more information.I can make LOTS of assumptions, but I'd
rather not do this multiple times.
So, for each row of data, you want to determine the FIRST column containing WO
and the LAST column containing WO.
Are you wanting to use VBA or Excel functions?
A simple function would
Yes:
First, make sure the functions are defined as "public".As in:In
Book1.xlsb:Public Function Test_Calc(iVal)Test_Calc = iVal + 10End Function
In Book2, use:=Book1.xlsb!Test_Calc(A2)
Paul-
“Do all the good you can,
By all the means you can,
In all
You can't have an Excel function replace the values in the cell.You could use
VBA, but it would be easier to simply use VLOOKUP.
In Cell B21, put:=VLOOKUP(C21,$A$10:$B$17,2,FALSE)Then copy this down to row 29.
HIghlight the cells and ctrl-CThen, right-click cell C21 and Paste Values.
I "assume" that you're using a userform.
Attached is a userform that contains:
Initialize event: populates the listbox with Range Names in the workbookListbox
Change Event: Selects Named Range (for display purposes)Delete Button:
1) Clears contents of Named Range selected in Listbox2) Deletes
1 - 100 of 1474 matches
Mail list logo