kandi X-RAY | collaborateR Summary
kandi X-RAY | collaborateR Summary
collaborateR
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of collaborateR
collaborateR Key Features
collaborateR Examples and Code Snippets
Community Discussions
Trending Discussions on collaborateR
QUESTION
I worked with some collaboraters on the site a couple of months ago to perfect the following code, however trying to re-trace my steps in respect to cell references is proving difficult. To clarify - all that's changed is the following cell references below.
Essentially:
- Column C has now changed to column J
- Column R has now changed to column O
- Column S has now changed to column P
- Column T has now changed to column Q
But for the life of me I can't work out where these cell references take effect in the code.
...ANSWER
Answered 2020-Jan-07 at 12:15So basically you want to adapt the macro to changed column-wise layout of your worksheet?
There is some missing information in your question:
which worksheet changed? (only change corresponding references)
did the order of columns change? (your arrays definitely rely on a fixed order of columns)
You have two places where you interact with Excel columns (shown below). This is where you need to make your changes.
- When assigning values to your arrays:
Columns C through L:
(presumably this requires your C->J change, so "C2:C" => "J2:J")
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install collaborateR
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page