Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 03-17-2018, 10:08 AM
14spar15 14spar15 is offline Create a sequence of numbers using a formula Windows XP Create a sequence of numbers using a formula Office 2000
Competent Performer
Create a sequence of numbers using a formula
 
Join Date: Mar 2011
Posts: 100
14spar15 is on a distinguished road
Default


What I need is a macro that I can run after data is entered into A1 and B1 and end up with the expected results in C1. The =ROW(INDIRECT(A1&":"&B1)) formula works fine if I run it manually but when I try to record the process into a macro I run into problems. The code that is in the recorded macro seems to be tied to the results of the A1 and B1 values that were used in the macro that was recorded so if I change A1 or B1 I do not get the expected results.
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequence numbers after each print MauricioPillon Excel 0 02-15-2018 08:11 AM
Create a sequence of numbers using a formula Wildcards - Sequence of Numbers at the Beginning of Each Paragraph qubie Word 1 11-30-2017 02:03 PM
How to assign numbers to letters and then create a formula to add them together for a rota Mskapri Excel 6 04-01-2017 03:05 PM
Need Help Deleting Numbers in Hour Format and Numbers in Sequence rsrasc Word VBA 1 10-12-2016 02:49 PM
How to Create a Locked Sequence of Buttons kcackin PowerPoint 0 01-24-2011 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft