Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-16-2019, 04:16 AM   #1
smiler44
Newly Registered User
 
Join Date: Jul 2008
Location: UK
Posts: 617
Thanks: 13
Thanked 9 Times in 8 Posts
smiler44 is on a distinguished road
macro to paste many variables into a cell

my mind is blank.

BH, CD, EF RC are all populated variables
I want to paste the contents into a cell, something along the lines of

activecell.value = BH & " " & CD & " " & EF & " " & RC
but this gives be an object required error
I've tried sheet1. at the beginning but this too is wrong

I cant believe I cant do this.

please can you help me?

smiler44

smiler44 is offline   Reply With Quote
Old 03-16-2019, 04:30 AM   #2
smiler44
Newly Registered User
 
Join Date: Jul 2008
Location: UK
Posts: 617
Thanks: 13
Thanked 9 Times in 8 Posts
smiler44 is on a distinguished road
Re: macro to paste many variables into a cell

sussed it, still got to get it right but I have it all but cracked

smiler44
smiler44 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy / Paste buttons and global variables OZmc Modules & VBA 5 01-29-2013 02:40 PM
Excel VBA Cell copy / paste Code request Rx_ Modules & VBA 2 08-17-2011 02:25 PM
Macro to cut an paste row based on Cell value mattP Excel 8 03-12-2010 03:38 AM
Copy and paste row dependant on a cell shard Excel 1 08-04-2009 08:18 PM
Macro to paste data into the next blank cell scott-atkinson Excel 3 09-24-2007 05:54 AM




All times are GMT -8. The time now is 01:03 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World