setting a range dynamically
Is it possible to dynamically set a range of cells in code.
Can I set the 2 and the 11 dynamically, something like
dim i, j
i = 2
j = 11
which obviously doesnt work
StevieH's Profile: http://www.highdots.com/forums/m96
View this thread: http://www.highdots.com/forums/t301312
range("a" & i & ":E" & j).copy
UNITED ARAB is in column A2 of present worksheet.
How do I build a formula to concatenate A2 into: ='UNITED ARAB'!$B$4
Should look something like: =A2+!$B$4
But my syntax is messed up.
"shank" <email@example.com> wrote in message
> ='UNITED ARAB'!$B$4
> UNITED ARAB is in column A2 of present worksheet.
> How do I build a formula to concatenate A2...Copying Formula to a dynamic range.
I have this formula
I have 5 different files in a folder, i need to open each file and add
a column called ID and add the above formula till the end of file and
then save the file.
The number of rows in each file is different.
Thank you for any help.
Message posted from http://www.ExcelForum.com/
One way (with some assumptions):
Dim myFileNames As Variant
Dim myPath As String
Dim iCtr As Long
...creating dynamic chart from within VB6
I'm creating a chart within a Visual Basic 6 program which has 3 series.
The first two series are static, and represent minimum/maximum limits for
the third series, which is a diameter vs. offset graph.
The diameter vs. offset graph will grow as more measurements are taken at
increasing offsets, and I'm looking for a way to construct a
I've read some of the articles and website tutorials from past queries to
this newsgroup, and it sounds like it is pretty easy to do this directly
My question: is there some way to do the same thing ...Smart Tags for Dynamics GP 2010
Will the Smart Tag download that was used for Dynamics GP 10 work for
Dynamics GP 2010? Is there a new download for GP 2010?
...How I open Microsoft Dynamics GP through Command Prompt
I want to Open Microsoft Dynamics GP through command prompt with out entering
user name password. I provide user name n password in the batch file. My
qustion is that if I open GP through command prompt I dont want to enter
password and i dont want to select company . I want that home page will
appare directly. dont ask y i require this but i need this . If u please help
me to finding out this.
Download Microsoft's documentation on the Integration Manager and look at the
last chapter. It discusses creating a macro to run on launch that will log a
user in and select a company, ta...Dynamic Chart with Two X Axis
I have a chart that has two columns for the X axis (date
and time). I am making the chart dynamic so it will
automatically update when new data are entered. To do
this, I have named the data in the two columns "Date"
and "Time." How do I enter these two names into the X
axis label on the chart?
Thanks in a advance for your help!
I looked at that website, but it was no help. Does anyone
else have a suggestion?
>> I have a chart that has two columns for the X axis (date
>> and time). I am making the char...Translated Microsoft Dynamics GP and/or Add-on Products
This week I am posting the last couple of articles in Translating Dexterity
If you are interested in know how to translate Dexterity applications or
just curious about how it can be achieved without any changes to source code,
please have a look at:
If you are a developer or partner who has created a translated version of
Microsoft Dynamics GP or an add-on product for Microsoft Dynamics GP, please
post a comment on the article with the details of what you...Dynamics GP 10 Trial Version Manufacturing Modules
Is there some sort of magic at install time to enable Manufacturing in the trial
Or (better) a way to install it from a working trial version?
...dynamically copy cell content and fill color
I know I can easily copy the contents of cell S1 to cell A1 by simply
putting =S1 into cell A1, but can I also copy the fill color and
content from S1 to A1 using some function?
Without code you are stuck with Copy>paste special>paste links then paste
Unless S1 has conditional formatting for fill color.
You could copy that CF to A1
Gord Dibben MS Excel MVP
On Wed, 23 May 2007 18:03:15 -0600, John Keith <firstname.lastname@example.org> wrote:
>I know I can easily copy the contents of cell S1 to cell A1 by simply
>putting =S1 ...Great Plains Dynamics
Where can I get a list of instructor led classes and scheduals that I can
provide to others in my company?
Do you have access to CustomerSource or PartnerSource? If you have access to
the former, select Training & Certification on the left. You can search
classroom training and eCourses.
You can try sending a message to email@example.com.
"Tom Parke" wrote:
> Where can I get a list of instructor led classes and scheduals that I can
> provide to others in my company?
Richard L. Whaley
"Tom Parke" wrote:
> Where can I ge...DYNAMIC RANGES #2
I am looking to develop a macro that will allow me to select a range
of cells dynamically. I have created a mapping template that maps user
defined fields to native fields, but each file that I map has a
different number of rows of data. Rather than simply selecting a range
of cells statically, I am hoping that there is a macro out there that
will allow me to catch all data in a column by dynamically assigning my
range to include all rows of data up to the last row containing
information and no more. To add to this issue, not all intermediate
rows will contain data, but it is important tha...Dynamics GP 10.0 SP4? When?
Has anyone heard whether Dynamics GP 10.0 SP4 is still on track for July, 2009?
It is planned for July, this month. Hopefully we should be seeing it anytime
Note: If you are a Microsoft Partner, You can also Login to Dynamics GP
partner forums at
"Tim Foster" wrote:
> Has anyone heard whether Dynamics GP 10.0 SP4 is still on track for July, 2009?
> Tim Foster
That's what I was expecting, but a ...Dynamics 6.0 in WinXP
Can I use Dynamics 6.0 with WinXP Operating System?
I am experiencing different errors in POP eversince I upgraded my O.S.
I have clients running 6.0 GP with no problems...but what are your POP errors?
"GP Support" wrote:
> Can I use Dynamics 6.0 with WinXP Operating System?
> I am experiencing different errors in POP eversince I upgraded my O.S.
I believe you have to be on a service pack of GP 6.0 to be compatible with
Windows XP - I don't remember which SP off the top of my head, but I want to
say 6 or 7. I think 6.0 went up to SP 12, and the...Dynamics GP 10.0 with Framework 3.51
I am installing a Dynamics GP 10.0 fresh install with SQL 2008 on a test
server, and it is having problem in finding Frame Work 2.0 even though it is
installed on the server. In the process of installing Dexterity shared
component 10.0 it is failing because Frame Work 2.0 is not installed on the
server. I have not tried uninstalling 3.51 from machine yet. I am wondering
are there any tricks to mimic the installation to skip this check.
...Dynamic distribution list based on direct reports??
Is it possible to create a dynamic distribution list for each staff that
reports to a specific manager??
On Wed, 16 Jun 2010 00:10:12 -0400, "JackH"
>Is it possible to create a dynamic distribution list for each staff that
>reports to a specific manager??
"Manager" and "DirectReports" work as filterable properties for some
of the "Get-*" cmdlets. Maybe they'd work...Dynamic Distribution groups
In oure organisation, we use multiple global address books to hold all
Each week we send out a news letter to all employees, retired-employees, and
some external persons.
Right now we use several Distribution Groups (DG) for each group, and put
these DG together in a other DG called "newsletter"
This method works, but needs a lot of administration to keep all the DG
I'm looking for a way to minimize the administration fot this.
The most perfect thing would be to create a new "Newsletter: yes/no" field
in the address books. So for e...Delete All Transactions in Dynamics GP
I am looking for a method that will help me delete all of the transactions
but keep all other data from a single company in Dynamics GP 10.0 SP4.
I want to do so because we were running a multi-company GP for final test
and we had to do a lot of modifications to the initial configurations. Now we
are stuck either with working with an old backup that has the old
configuration that need modification but with no transactions, or to delete
all of the transaction from the company.
I have done a small research on the web but i couldn't find anything like
this. Dyn...Dynamic IP for MX record.
Since my ISP only provide a Dynamic IP, is that anyway I can use the
Dynamic IP for MX record or A record ? Is it any way can help me to solve
this problem. I used to have a static IP for my server at home, but since I
change the ISp and it wont' work now. Is anyone could help ??
Zoya <firstname.lastname@example.org> typed:
> Hi All,
> Since my ISP only provide a Dynamic IP, is that anyway I can use the
> Dynamic IP for MX record or A record ? Is it any way can help me to
> solve this problem....Dynamics GP 11.0
Is GP 11.0 beta available for download? We are a gold certified partner. We
would like to test the GP 11.0 beta, be a beta site or learn more about GP
11.0. Please let us know how to go about this. Thanks, VJ
If you are interested in receiving more information on the GP 11.0 "beta
program" please email your partner information to email@example.com.
"This posting is provided "AS IS" with no warranties, and confers no rights."
> Is GP 11.0 beta available for download? We are a gold certified p...Smart Tags Not recognising Microsoft Dynamics GP data in Word
Give no error in application. sterror.text gives
Error for user DOMAIN/FirstName.Suname
Begin Term File Creation: 13/11/2006 09:41:37. Error Number = -2147217900
Date = 13/11/2006 09:41:37
Description = Line 1: Incorrect syntax near '.'.
Source = Microsoft OLE DB Provider for SQL Server
Last DLL Error = 0
Module = SmartTagCB:ReadTokens
Finished Term File Creation: 13/11/2006 09:41:37. Creation Time: 0 Seconds.
Seems problem may lie in period not being recognised in domain user with
firstname.lastname format. Is there any ...Adding Google Map to CRM iFrame (plus dynamic content to URL)
Here's a URL for google maps:
If I were to enter:
http://www.google.ca/maps?f=q&hl=en&q= radio beacon inc. loc: toronto
It would return the company Radio Beacon Inc. located in Toronto.
I can dump this into an iFrame URL but I don't want it to be hardcoded. I
would like to pass the Account Name the URL.
I've seen some posts but I have not been able to make it work. I hope
Michael Höhne is out there to help me too :)
From OnLoad on my Account Form I have added this code:
crmForm.all.IFRAME_AccountMap.src = http://...Dynamics GP 9 on an Ultra Mobile PC
Just an FYI, Dynamics GP 9 seems to run just fine on a Samsung Q1 Ultra
Mobile PC. I can definitely see some warehouse and retail applications for
these types of devices down the road. No rewriting of software for a Pocket
PC, built in touch screen, Wifi and bluetooth.
Mark Polino (DynamicAccounting.net)
That's great - thanks for testing it out and letting us know Mark!!
"Mark Polino" <firstname.lastname@example.org> wrote in message
> Just an FYI, Dynamics GP 9 seems to run just fine ...Creating dynamically arrays, is that possible in VBA?
I would like to do the following, but I am not sure it is doable in
VBA. I saw it in Php, so I have a little hope it is.
I have a spreadsheet full of range names. They are all of the form
"S1.Name3.Subname2". Basically I would like to load in VBA all the
values from these rangenames in one macro.
For the moment I do it manually be doing
and I do the same for all the range names. I have found on a post on
this group a lovely program called NameManager that allows t...Dynamic Range Not Working
I created a named range called HarvestData.
In the refers to box I typed the following:
I hit ok.
If I go back into the "Define Name" dialog box and select the name
"Harvest" and have it point to the actual range in the worksheet, it
highlights cells A2:B20. The problem is, there are data in columns A
to N. Why is it not recognizing the rest of the columns? I discovered
this problem because I'm referencing column h in a VLOOKUP and it is
not returning data that I know is there.
What am I doing...