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.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: Troubleshooting:12gb of shared graphic memory GONE !,Troubleshoot:1606 error code trying to install java,Troubleshoot:1935 error assembly policy 8.0 Microsoft VC80.CRT,Type win 32,[Solution] 2 Files save on excel 2007,How to Fix - 2 home groups on 1 computer network?,IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32

No comments:

Post a Comment