Downlooad and Install Dll Files: Fast Solution to Error: 2 easy questions regarding coding syntax

Tuesday, March 15, 2016

Fast Solution to Error: 2 easy questions regarding coding syntax

2 easy questions regarding coding syntax

Hopefully this should be an easy one :-

I have been advised to avoid using the 'command?' select as it causes issues.
I have managed to do this but have a problem with the following :

I need to copy data from a sheet called 'reviews' into a sheet called 'class list' - this bit is OK for single cells - I have used

Sheets("class list").Range("e" & 3 +tt ) = Sheets("reviews").range("g" & I + 2)

But, the ranges to be copied are depandent upon a variable and so is the place to be copied to.
The code below works fine but it uses the 'select' method.
Can you show me how it is written without the select ?

Sheets("reviews").select
Range("a1").select
ActiveCell.OffSet(I+1, s(k,2) * 9 -5).Range("a1:b1").select:Selection.Copy
Sheets("class list").select
Range("e" & 3 + tt").select
Selection.PasteSpecial

The second is probably even easier :
To code a single cell , say G5, using a variable I would use the code Range("G" & I) - where I is 5
Can you use a similar syntax for a range of cells - I've tries a variety of examples like - Range("G" & I:"H" & K) - but none of them work.

Thanks in advance !

Solutions to the Problem 2 easy questions regarding coding syntax

Download SmartPCFixer for Free Now

In your second answer, why does the first component "G & I &" have a different syntax than the second component "H" & K ?

The syntax for a range of cells is Range("G5:H36").
You could split this into Range("G" & 5 & ":H" & 36).
Replacing 5 with the variable I and 36 with the variable K, you get Range("G" & I & ":H" & K).

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Another Safe way to Fix the Problem: 2 easy questions regarding coding syntax:

How to Fix 2 easy questions regarding coding syntax with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.